Determine the min value over rows in a group using MINX in PowerPivot
I got a question that proved more challenging than I imagined.
I have a report that displays the following values. It shows Days in stock per employee per Continent and per Country. The days in stock is a calculated measure:
=DimGeography[DaysInStock per store] / DimGeography[NrOfEmployees in service]
which again contains of two calculated measures. The question i got was if it was possible to show the minimal value of the measure [days in stock per employee] for each country grouped by Continent: