Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all
How can I do with dax a dynamic sumifs like this:
Basically, sum if the SKU and plant are the same.
pbix: https://1drv.ms/u/s!ApgeWwGTKtFdhwWaPpXv_NVUuIFM?e=1wDmQ4
Thanks!
Solved! Go to Solution.
You don't need SUMIFS() in Power BI. Just use SUM(). It will sum based on the filter context, so if you add the SKU and Plant to a matrix visual, then use the following measure, it will sum only where it equals the SKU and Plant.
Measure = SUM(Table_query__51[%])
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi @o59393 ,
Not very clear of your requirement.
YOu can just use SUM
SUMSKUPLANT= SUM(Table_query__51[%])
or incase you want to group by SKU
SUMSKU = CALCULATE(SUM(Table_query__51[%]), ALLEXCEPT(Table_query__51,Table_query__51[SKU]))
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
You don't need SUMIFS() in Power BI. Just use SUM(). It will sum based on the filter context, so if you add the SKU and Plant to a matrix visual, then use the following measure, it will sum only where it equals the SKU and Plant.
Measure = SUM(Table_query__51[%])
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting@o59393 , You need to tell exact need.
Sumx(filter(Table[H] ="ABC"),Table[G])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
101 | |
78 | |
70 | |
63 |
User | Count |
---|---|
141 | |
106 | |
101 | |
85 | |
72 |