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:

ABC123SpainMadridBad 
ABC123YokeYoke LeftCritical
ABC123IrelandDublinNot present
ABC123GermanyHamburgNot present
ABC123SpainBarcelonaNot present
ABC123EnglandLondonNot present
ABC123PortugalBragaNot present
ABC123DenmarkCopenhagenNot present
ABC123SpainSevillaOK
ABC123ItalyRomeOK
ABC123ItalyMilanOK
ABC123ItalyTurinOK
ABC123PortugalLisbonOK
ABC123GermanyDortmundOK
ABC123PortugalPortoOK
ABC123EstoniaTallinnOK
ABC123YokeYoke RightOK
ABC123ItalyBolognaOK
ABC123GermanyBerlinReally Bad

and i want to create a alert matrix , I have hierarchy columns country/city, the country level:

 

and as you can on germany, the status is Not present.

City level:

and i have a alert in Berlin.

I wonder if is possible to change then value in the country level in Germany from Not present to Really Bad, I can only select first or last status in matrix values.

Thanks all help.

 

 

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.

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi , I have edit my post, I dont want to sort the column instead I want to change the values in the highest level of hierchy.

  • 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.