Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi experts
I have the following table:
Week | KPI_A | Measure(KPI_B) | Measure(Dif) |
1 | 10 | ||
2 | 12 | 10 | 2 |
3 | 14 | 12 | 2 |
4 | 16 | 14 | 2 |
TOTAL | 52 | 52 | 0 |
I've created a measure [KPI_B] that equals the value of [KPI_A] of the previous week. I didn't really care about the total of [KPI_B] (because it's a hidden measure) so for the total I stayed with the sum of [KPI_A], as I can't calculate a previous week.
I'm actually having trouble with measure [Dif], that's the difference between [KPI_A] and [KPI_B]. I want to be able to sum measure [Dif] for week 1 to 4 on Total row, so it change from 0 to 6.
Week | KPI_A | Measure(KPI_B) | Measure(Dif) |
1 | 10 | ||
2 | 12 | 10 | 2 |
3 | 14 | 12 | 2 |
4 | 16 | 14 | 2 |
TOTAL | 52 | 52 | 6 |
6: sum of the measure on weeks 1 to 4
Do you think it's possible? Thanks!
Solved! Go to Solution.
write a new measure like this
Dif fixed = SUMX (VALUES('table'[week]),[Dif])
write a new measure like this
Dif fixed = SUMX (VALUES('table'[week]),[Dif])
Thanks! I really needed this