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 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
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 |
---|---|
106 | |
105 | |
79 | |
68 | |
61 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
70 |