cancel
Showing results for
Did you mean:
Helper III

## 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

1 ACCEPTED SOLUTION
Super User III

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)

5 REPLIES 5
Super User III

Hi @Minakshi ,

Just use following DAX for creating a column:

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

Thanks,

Pragati

If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Super User III

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)

Super User III

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)

Helper III
 shop id purity 1 2 1 2 2 1 2 1

I have table like this and I want purity = 3

I want to select only one entry associated with shop id.

Super User IV

@Minakshi Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

---------------------------------------

@ me in replies or I'll lose your thread!!!

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Announcements

#### Happy New Year from Power BI

This is a must watch for a message from Power BI!