Forum Discussion

Minakshi's avatar
Minakshi
Icon for Resolver I rankResolver 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)

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi Minakshi ,

 

Just use following DAX for creating a column:

CalcCol = CALCULATE (SUM(Tablename[purity1], FILTER(Tablename, Tablename[shopid] = EARLIER(Tablename[shopid] )))

 

Thanks,

Pragati