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.

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Ashish_Mathur, quick follow up on this.

 

Is there an easy way to add a condition to the formula that the ranking is conditional on product not being blank?

 

Recently had a case where a product was missing, but since it contained the largest value, a blank was returned.

 

Thanks!

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