Showing results for 
Search instead for 
Did you mean: 
ekx Frequent Visitor
Frequent Visitor

calculated measures in values and columns

Hi all, 


I wish to end up with a matrix like this: 





Measures in bold have been calculated from my data set as calculated measures. even the header called "actual. budget and Past year". I have managed to place the ratios on the rows under the "value" box but icannot put the calculated measures of "vs budget and Vs past year" in the column. Is there a way to do this? 



Thanks so much for your help! 




Community Support Team
Community Support Team

Re: calculated measures in values and columns

Hi @ekx ,


You can put the ratios onto the Rows, and put the actual, budget and Past year onto Values.


Best Regards,



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ekx Frequent Visitor
Frequent Visitor

Re: calculated measures in values and columns

The ratios are calculated measures and cannot seem to be placed in the rows.

Helpful resources

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 426 members 4,241 guests
Please welcome our newest community members: