Forum Discussion
Summing conditional measure
Please see this video. You need to use SUMX iterating over a SUMMARIZE of item, type, subtype, and region referencing your Corrected Supplies measure.
Power BI - Tales from the front #01 - Getting the Right Total - YouTube
Pat
Please see this video. You need to use SUMX iterating over a SUMMARIZE of item, type, subtype, and region referencing your Corrected Supplies measure.
Power BI - Tales from the front #01 - Getting the Right Total - YouTube
Pat
Hi, I tried using that bit didnt work for me 😞
It looks sowmthing like this but I tried using different versions. Nothing seems to be working:
SUMX(SUMMARIZE(Main_tbl, Main_tbl[_date],Main_tbl[_type], Main_tbl[Key]), CALCULATE( [Corrected Supplies]))
Corrected Supplies = If (Y > 1.5, 1.5*Demand(X), W)
(in the table all are measures btw everything is calculated based on some date restrictions)
