Forum Discussion

Minakshi's avatar
Minakshi
Resolver I
6 years ago
Solved

need help with DAX

  Hello Everyone, I need to calculate purity1 sum based on shop_id. Kindly help me with DAX expression. With my DAX it is coming wrong.   Thanks
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Minakshi ,

     

    Measure 5 = SUMX( SUMMARIZE('Table (3)','Table (3)'[shopid], "S",MAX('Table (3)'[purity])),[S]
)

     

     

     

    Regards,
    Harsh Nathani
    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Minakshi ,

 

CALCULATE (SUM(Table[purity1], ALLEXCEPT(Table,Table[shopid])

 

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Minakshi ,

     

    Measure 5 = SUMX( SUMMARIZE('Table (3)','Table (3)'[shopid], "S",MAX('Table (3)'[purity])),[S]
)

     

     

     

    Regards,
    Harsh Nathani
    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)