Forum Discussion

ThisIsIt's avatar
ThisIsIt
Frequent Visitor
3 years ago
Solved

Card from Matrix (highest value)

Hello Everyone!  Maybe you can can?  I'm trying to get create a card that shows the max value from a matrix I have (minus the totals).  I thinking I need to create a DAX to do this, but haven't been ...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    ThisIsIt , a new measure like

     

    Maxx(Summarize(Table, Table[Product], Table[Country]), [Measure])

     

    or

    calculate(

    Maxx(Summarize(Table, Table[Product], Table[Country]), [Measure]), allselected())

amitchandak's avatar
amitchandak
Super User
3 years ago

ThisIsIt , a new measure like

 

Maxx(Summarize(Table, Table[Product], Table[Country]), [Measure])

 

or

calculate(

Maxx(Summarize(Table, Table[Product], Table[Country]), [Measure]), allselected())

ThisIsIt's avatar
ThisIsIt
Frequent Visitor
3 years ago

Thank you very much!  The "Maxx(Summarize(Table, Table[Product], Table[Country]), [Measure])" solution worked for me.  Much appreciated!