Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sort values in matrix values

Hi, i have one table with 4 columns like machine, country ,city  and status. pls take a  look at the table: ABC123 Spain Madrid Bad  ABC123 Yoke Yoke Left Critical ABC123 Ireland D...
Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi Anonymous,

     

    Is this what you want?

    Try measure as:

    Measure = 
IF(
    MAX('Table'[country])="Germany",
    "Really Bad",
    MAX('Table'[status])
)

    The pbix is attached.

     

    Best Regards,

    Link

     

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

v-xulin-mstf's avatar
v-xulin-mstf
Community Support
5 years ago

Hi Anonymous,

 

Is this what you want?

Try measure as:

Measure = 
IF(
    MAX('Table'[country])="Germany",
    "Really Bad",
    MAX('Table'[status])
)

The pbix is attached.

 

Best Regards,

Link

 

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