Matrix : How to show only numbers where value in row header matches value in header column

[Possibilitis]

Hi experts, 

I have have  challenge I need your help with. I'am using a matrix to show percentage number  which is a result of division of revenue by expenses.  The perentage is displayed by region , city .... . currently the matrix shows all numbers for all regions as you can see in the screen shot included. 

What I am looking for is a way to show the numbers in matrix ONLY when the value in column header matches the value in the row reader as I have underline in read. The numbers where that condition is not meet should NOT be visible. 

Does anyone knows how to achieve this requirements?

Thanks so much for your help! 

[lbendlin · Accepted solution]

The simple answer is "return BLANK() in your measure when they don't match".  But this is much more complex.  What do you expect to see in the totals?

[Anonymous]

Hi @Possibilitis ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

Create measures

Value = SELECTEDVALUE('Table'[revenue ])/SELECTEDVALUE('Table'[expenses])

Measure = 
IF(
    SELECTEDVALUE('Table'[Region]) = SELECTEDVALUE('Table'[Region.Second]),
    [Value],
    BLANK()
)

Use measure as value of matrix
Final output

Best regards,
Albert He

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

[Possibilitis · Accepted solution]

Hi @lbendlin thanks so much for your help, it worked fine for me. 

[lbendlin · Accepted solution]

The simple answer is "return BLANK() in your measure when they don't match".  But this is much more complex.  What do you expect to see in the totals?