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.
Hello all,
Hoping someone can help me out with this.
I've created a measure called 'Delta. Calculated as
DELTA = SUM(TABLE[WARRANTYUNITS]) - CALCULATE([AVG.WARR.]),ALL(TABLE))
AVG.WARR. is another measure calculated as
AVG.WARR = SUM(TABLE[WARRANTYUNITS]) / DISTINCTCOUNT(TABLE[MONTH))
I don't need a total sum of Delta, I need to add the result for Month 2 to Month 1, Month 3 to this and so on
The other picture is the table in excel using the correct calculation
I'm hoping to avoid linking the Delta by Month output into a new table so as to avoid refreshing the data continuously
Is there perhaps something I can do with time intelligence to make this calculate correctly?
Thank you for any help that may be provided!
Solved! Go to Solution.
Hi @rjeffers,
You can try to use below mesure to calcualte running total:
CUSUM = VAR AVG = SUMX ( ALL ( TABLE ), [WARRANTYUNITS] ) / 12 RETURN SUMX ( FILTER ( ALLSELECTED ( TABLE ), [MONTH] <= MAX ( [MONTH] ) ), [WARRANTYUNITS] ) - AVG * COUNTROWS ( VALUES ( TABLE[MONTH] ) )
Regards,
Xiaoxin Sheng
Hi @rjeffers,
You can try to use below mesure to calcualte running total:
CUSUM = VAR AVG = SUMX ( ALL ( TABLE ), [WARRANTYUNITS] ) / 12 RETURN SUMX ( FILTER ( ALLSELECTED ( TABLE ), [MONTH] <= MAX ( [MONTH] ) ), [WARRANTYUNITS] ) - AVG * COUNTROWS ( VALUES ( TABLE[MONTH] ) )
Regards,
Xiaoxin Sheng
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |