Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
spandy34
Responsive Resident
Responsive Resident

Visualisations Advice

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 

 

spandy34_0-1645630593661.png

 

1 ACCEPTED SOLUTION

@spandy34 

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

View solution in original post

26 REPLIES 26

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. 

spandy34
Responsive Resident
Responsive Resident

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]

spandy34
Responsive Resident
Responsive Resident

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. 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.