Add measure to matrix visual Column

[tshep]

I have a matrix visual that shows basic project data for different buildings. In the columns of the visual I have data such as the total square footage of the building, and Amenity square footage.

I then created a measue (Amenity Area Ratio) that calculates the ratio of amenity sf to total building sf.

Amenity Area Ratio = DIVIDE(CALCULATE(MAX(vwProjectCustomField[Amenity SF])),CALCULATE(MAX(Project[square_feet])))

I want to add that ratio to the column of the matrix (just below the Amenity SF line item). However, I can only place the ratio measue in the Values.

What do I need to do to make/convert the measue into something that can be placed in the column? 

[Anonymous · Accepted solution]

Hi, @tshep 

In Power BI, you can't add measures to a matrix's column by default, and here are the main reasons:
Measure is usually a number of operations, such as sum, max, average... These operations need to be computed in the context of the visual.

Here's my test, I tried to put measure in column/row, but it didn't work:

Here are some alternative solutions to display the measure as a column in the matrix:
1. Use the Tabular Editor tool to create a calculation group, the detailed tutorial can be found in the link below.

Use Measures in Columns of a Matrix Visual - Goodly

2. Add a calculated table, manually add the special row sum column name as the value. You can click on the links below to learn more about similar solutions for cases with the same needs as yours.

Solved: Display a measure as a column in matrix visual - Microsoft Fabric Community

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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