need help with DAX

[Minakshi]

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

[Pragati11]

Hi @Minakshi ,

Just use following DAX for creating a column:

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

Thanks,

Pragati

[harshnathani]

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)

[harshnathani · Accepted solution]

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)

[Minakshi]

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. 

[Greg_Deckler]

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