Finding the MAXX value problem

[Avi SinghParticipant Started: 5Replies: 7Total: 12]

I am trying to find the maximum number of products with a specific color;

[Max Number of Product Color] := MAXX ( VALUES (Product[Color]), COUNTROWS(Product))  does not work. Gives the number of all products

[Max Number of Product Color] := MAXX ( VALUES (Product[Color]), CALCULATE(COUNTROWS(Product))) Does work

The question is why?

 

[austinsenseParticipant Started: 0Replies: 2Total: 2]

Using an aggregator formula like COUNTROWS (or SUM, MAX, AVG, etc) destroys the row context.  So MAXX is iterating through every row and the CALCULATE in the expression forces the COUNTROWS to look at that row individually.

[Avi SinghParticipant Started: 5Replies: 7Total: 12]

Thanks austinsense. I was confused as I didn’t understand that aggregators had row context (which 20/20 hindsight now sounds logical). I knew that calculate turned row into filter context. Not likely to forget this one.

[Author]

Posts