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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
santib2016
New Member

Using calculated total/subtotals in a new measure?

Is there a way to use the calculated total in a matrix, into a new measure?

so far i wasnt able to find a way, not sure if its even possible.

Thanks!

 

1 REPLY 1
Sean
Community Champion
Community Champion

No you have to create a measure with those specific filters - If i understand what you are asking.

 

You want to take the subtotal for say a specific company in Dec 2015 or for the whole year - you can't take it from a matirx.

 

If you are trying to put Measures on Rows you can't do that either.

 

But please Vote for these 2 ideas to improve the Matix

Idea 1

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9207006-matrix-collapse-expand-bu...

Idea 2

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10948962-matrix-measures-or-value...

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.