Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
Hi
I want to display the following table - with amazing help I have been able to produce measue here displayed as the column rows but I am wanting to know how to get the current month measures, (you have also helped with) year to date and Total measure as a column header and then ultimately Grand Totals.
Im just struggling with the best way to approach this they all appear in a single line if I put them in the Values of a cross tab.
Thank you for your patience with me
@MarkLaf @tamerj1 @goncalogeraldes
Solved! Go to Solution.
You have created a master measure for the number of revoveries in which you grouped 9 measures.
now create another master measure for amount recovered that groups the 9 relared measures the same way as the first one. Copy the same master measure only change its named and the 9 measure names inside.
then do the same for th team fee income.
Then adf the these two master measures into the values of the matrix
Great!
Now the measures are showing the grand total as they are not filtered by anything. So start selecting something on the the slicers and see the results.
Where do I define them?
I mean apparently they are already defined in your model in separate measure right?
Now just refer to each measure's name inside square brackets
VAR xxxx = [measure name]
Copy the name as opposed to the full measure code?
Yes the name only but inside square brackets [ ]
Of course the grand total is another subject. Let's first check if this works.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 9 | |
| 5 | |
| 4 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 13 | |
| 9 | |
| 8 | |
| 8 | |
| 7 |