Formatting Values in a Matrix Visual

[Anonymous]

Hello,

I am creating a matrix and have 2 types of counts. We have counts by the category and then a running total count that consists of the following measure: 

RunningTotal = CALCULATE(SUM('Main Table'[Count]), FILTER(ALL('Main Table'), 'Main Table'[Identified]<= MAX('Main Table'[Identified])))

When I add this measure as a value to the matrix, it automatically adds it as a new column, however I am wanting this value to appear as a row in the matrix. Any advice on how to format this visual accordingly?

[Anonymous]

Here is a visual of the current visual for reference

[az38 · Accepted solution]

Hi @Anonymous 

Measures cannot be used as a row for matrix visual. you need to use column or calculated columns as rows. in your case it would be

RunningTotal Column = CALCULATE(SUM('Main Table'[Count]), FILTER(ALL('Main Table'), 'Main Table'[Identified]<= EARLIER('Main Table'[Identified])))

[Anonymous]

Hi @az38 ,

Thanks for the tip, that seems to be working. One follow-up question if you don't mind. Is there a way when I add that column to my matrix for it to appear at the same level instead of having to drill down to get to those values?

[az38]

@Anonymous 

not sur ewhat do you mean. maybe you need to add this column as Column for Matrix visual

[Anonymous]

The requirement I have is to add that running total count to the bottom of this matrix, where the red box is highlighted.

Right now, with the new calculated column, I need to drill down on this visual to see the running total

Hopefully this helped to make a little more sense.

[az38]

@Anonymous 

Unfortunately, there is no such option 😞 you can create an idea here https://aka.ms/PBI_Comm_Ideas 

[Anonymous]

Gotcha- thank you for your help!

[az38]

@Anonymous 

if you have no more questions - please, mark any useful post as solution to close this thread