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.
I am going agg trying to figure this out and am running out of time to hit deadline.
I have a matrix that has 3 measures as shown below:
My totals are obviously not correct. What am I doing wrong?
Rev | a/p % = DIVIDE([Total Rev],[Rev | plan])
Rev | a/p $ = if(isblank([Rev | a/p %]),0,[Total Rev]-[Rev | plan])
Rev |fc/p% = DIVIDE([Rev | fc],[Rev | plan])
You would need to think about what you "want" to happen. Realize the totals are nothing more/less than evaluating your measures WITHOUT a filter on Fiscal Quarter. It's not like it is somehow using the rows above it to build a sum or average or whatever.
36.05% is "correct" in that it is [Total Rev] / [Rev | Plan] ... completely ignoring Fiscal Quarter. (You probably have a PLAN for Q2, but not Revenue yet... so the % looks small).
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |