Show a measure only as a Total Column in Matrix (ISINSCOPE)

[zohlander]

Hello, I hope that you are well! I am facing a problem that I can't solve and I need help.

I've created a matrix with two measures: Sales Amount and Target. My idea is to hide the measure "Target" from the date columns. I could solve it by using ISINSCOPE, changing the measures name to "" and decreasing the column width to the minimum. 

But the problem is that, when deleting the name of the measure, the column with its total has no name and it is not very intuitive for the client. Also, in the actual report I have to add more columns like this and, when hiding them, it shows that there is space in between.

It looks bad

Do you know another approach to solve this?

[Anonymous · Accepted solution]

Hi @zohlander ,

I create a table as you mentioned.

Then I create a measure and here is the DAX code.

Measure = 
IF(
    ISINSCOPE('Table'[Date]),
    BLANK(),
    MAX('Table'[Target])
)

Finally I put it into the matrix visual.

Best Regards

Yilong Zhou

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

[lbendlin]

 I could solve it by using ISINSCOPE, changing the measures name to "" and decreasing the column width to the minimum. 

Keep the name. Set the column header word wrap to off, disable auto column resizing, and then minimize the column width.

[gck02]

This solution is not future proof. As soon as new values appear in the column headers, the column header is populated with your measure name even if it is to display blank values. 

For example, if you use a date hierarchy, you have to change the column headers for each and every level of the hierarchy; and as soon as new dates arise, the manual resizing is mandatory.