Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Return largest category based on a sum

Hi there,   I am looking for a (hopefully) simple DAX measure to solve the following problem.   I have a range consisting of a number of employees, a chosen product, and their savings in each pro...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    These measures work

    Total amount = SUM(Data[Amount])

    Top product = FIRSTNONBLANK ( TOPN ( 1, VALUES ( Data[Product] ), [Total amount] ), 1 )

    Hope this helps.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

     

deevo's avatar
deevo
Icon for Helper I rankHelper I
3 years ago

This worked perfectly. Thank you so much. Your knowledge is amazing. 

I will have to go back and break each formula down to understand how it works.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

You are welcome.  Thank you for your kind words.  If my previous reply helped, please mark that reply as Answer.