I need to calculate purity1 sum based on shop_id. Kindly help me with DAX expression. With my DAX it is coming wrong.
Go to Solution.
Hi @Minakshi ,
Measure 5 = SUMX( SUMMARIZE('Table (3)','Table (3)'[shopid], "S",MAX('Table (3)'[purity])),[S]
Regards,Harsh NathaniDid I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
View solution in original post
@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/1116882Also, 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/38490The most important parts are:1. Sample data as text, use the table tool in the editing bar2. Expected output from sample data3. Explanation in words of how to get from 1. to 2.
Proud to be a Super User!
I have table like this and I want purity = 3
I want to select only one entry associated with shop id.
CALCULATE (SUM(Table[purity1], ALLEXCEPT(Table,Table[shopid])
Just use following DAX for creating a column:
CalcCol = CALCULATE (SUM(Tablename[purity1], FILTER(Tablename, Tablename[shopid] = EARLIER(Tablename[shopid] )))
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.