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.

     

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

Hi,

Share some data and show the expected result.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Ashish_Mathur, please see below

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks Ashish_Mathur, exactly what I was looking for

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        5 years ago

        You are welcome.