Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
please. I don´t know how I edit formula. Total sum is wrong.
Thank you,
Ondřej
Solved! Go to Solution.
HI @Fidzi8 ,
Try using SUMX
Measure = SUMX(Table, Other MEasure Created)
or
Measure = SUMX ( SUMMARIZE(Table, Table[Plant],Table[Customer]) ,"Calc lost" , Other Measure Created)), Calc lost)
or
Measure = SUMX(VALUES(Table[Plant]) , Other Measures)
https://community.powerbi.com/t5/Desktop/Total-Measure-Wrong/m-p/1200928
Regards,
Harsh Nathani
@Fidzi8 This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
HI @Fidzi8 ,
Try using SUMX
Measure = SUMX(Table, Other MEasure Created)
or
Measure = SUMX ( SUMMARIZE(Table, Table[Plant],Table[Customer]) ,"Calc lost" , Other Measure Created)), Calc lost)
or
Measure = SUMX(VALUES(Table[Plant]) , Other Measures)
https://community.powerbi.com/t5/Desktop/Total-Measure-Wrong/m-p/1200928
Regards,
Harsh Nathani
@Fidzi8 , Try like
sumx(Summarize(table, Table[plant], table[customer], "_1",([Cost/tn]-[CostP])*[Qty]),"_1")
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |