need help with DAX

Hi Minakshi ,

Just use following DAX for creating a column:

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

Thanks,

Pragati

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.

I have table like this and I want purity = 3 

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

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)