Maximum of a calculated measure

[Nickuk84]

Hi

Little bit of a complicated one (for me) so i'll explain as best I can and would appreciate some help from the experts (you )

I have create a measure that basically says if the cumulative total is less than or equal to whatever the percentage threshold is (this changes via a slicer), then take the ranking value + 1 (it has to have the plus one long story but that's the thing making it difficult), I want to find the maximum value of this calculated column:

IF([Cumulative Total]<=[Percentage Threshold],[Broker Parent Ranking],0)+1

is it possible?

 

[gazpage]

You say both Measure and Calculated Column in your post. For calculated Column it's just a simple MAX ( Table[Column] ).

For a measure you need to iterate over the list that you want the measure calculated over. For example if my data is for one year and I want the maximum monthly value it would look like this:

MAXX ( 
    VALUES ( Table[Months] ),
    [Measure]
)

 

[tallan]

What are you finding difficult about adding the 1? Do you not want it added when the IF condition is false or is there another issue that you are experiencing.

Also, what calculated column are you talking about? Is it [Broker Parent Ranking] or another column?

Tom
PowerPivotPro - Transforming your Business with Power Pivot and Power BI