Forum Discussion

corbs's avatar
corbs
Frequent Visitor
1 year ago

MAX OF A MEASURE IN CONDITIONAL FORMATTING

I need help. I have a metric that is a %, simple one:    YTD Metric= var numerator = CALCULATE(SUM(fact[METRIC_VALUE]),fact[METRIC_TYPE]="numerator") var denominator = CALCULATE(SUM(fact[METRIC...
General Comment
Interesting Links
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi corbs , hello DataNinja777 and danextian, thank you for your prompt reply!


Use the following measure to dynamic calcualte:

MAXX Year = 
MAXX(
    ADDCOLUMNS(
        SUMMARIZE(
            ALLSELECTED('Calendar'[Year]),  
            'Calendar'[Year]  
        ),
        "@rev", [YTD Metric]  
    ),
    [@rev]  
)

 Result:

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

corbs's avatar
corbs
Frequent Visitor
1 year ago

Thank you for your reply, Anonymous !

The measure to get the max dynamically it's working just fine.

But now, my measure to flag if max = current ytd is not anymore:

YTD and MAXX and matching, but flag remains 0. 

 

 

This is what I was using before (and I was working). Should I remove year context from this one as well? I did that but is not working 😞 

 
Highlight Max =
IF(
    [YTD Turnover]= [MAX YTD],
    1,
    0
)

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi corbs , thank you for your feedback.

     

    I am afraid I could no reproduce your issue with the measure Hightlight Max:

    If possible, could you please upload your sample pbix file for further troubleshooting?

     

    Please note, you could upload it with the same structure but without the actual data.

     

    You could also check my updated pbix file for clues.

     

    Best regards,

    Joyce

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.