Create Formatting Conditional every Group

[mrbajana]

I have a matrix like the attached image, it is possible to create a conditional format of icons or a formula with DAX that tells me if the value is greater or less for each of the groups that I have in the matrix. I want the icon to tell me if it is higher or lower according to the group

[v-kkf-msft]

Hi @mrbajana ,

Try the following formula:

Measure = 
var _Max = 
    MAXX(
        ALLEXCEPT( 'Table', 'Table'[Grupo] ),
        CALCULATE( SUM('Table'[ADM]) )
    )
return 
    IF(
        SUM('Table'[ADM]) = _Max, 
        "ColoredArrowUp",	
        "ColoredArrowDown"
    )

Then set icons based on Measure:

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

[mrbajana]

Thanks for your answer, I apply your formula, I dont find where to send my pbix file so  I send you the pictures of my file , sure where I see I only get the red arrows,  it must be some little trick that is missing  because of the model.

[v-kkf-msft · Accepted solution]

Hi @mrbajana ,

Try the following formula:

Measure = 
var _Max = 
   MAXX(
       ALLSELECTED('Table'[Teatro]),
       CALCULATE( SUM('Table'[ADM]) )
    )
return 
    IF(
        SUM('Table'[ADM]) = _Max, 
        "ColoredArrowUp",	
        "ColoredArrowDown"
    )

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

[mrbajana]

Thank you so much It Works.