Hide Dynamically datas in a matrix

[NathanD]

Hello Everyone, yes i've already posted yesterday about a similar problem but did explain i think i oversimplified my problem and it resulted in helpful people answering beautifully my question but it did not solve my problem 

To explain my problem i'm working on a Dashboard that displays interesting numbers about education. I'm working with several filters and the data is quite sensible. I want to be able to put what we call in France the "Statistic Secret" to prevent anyone to find specifically people that succeeded/ or not, at their diploma. 

The usual way is to mask any data that could lead someone to identify 5 people or less. 

So that is what i want to do and here is the matrix i want to apply it on. 

As you see it is a matrix with 2 levels, "GFE" and "Title of diploma", i will call them Group and SubGroup. 

For the two integer(not the %) columns that i will name columnA and columnB that is what i want to do:

-If there is one value <5 in column A or B, mask both value (so the value <5 cannot be calculated via the %)

-If there is only one subGroup in a Group that has his values masked. Mask another SubGroup values in the Group (so it cannot be calculated via the subtotal of the Group) 

-if there is only one Group that has his values masked, mask another Group values (So the initial Group values cannot be calculated with the total) and all of his SubGroup values (So the second Group masked cannot be reconstituted)

On this example all the datas are in the same table but i have other pages of the Dashboard where there are matrixes that joins multiple tables like diplomas name are on a different table than the values

I'm very thankful if someone can solve this problem as it is tearing myself up !

Have a nice day

[MattAllington]

My general advice is this; work out how you would solve this in Excel if you had this problem, then apply the same approach here. 

Convert your measures to use variables, if you haven't already. 

measure A= VAR result = <your code>
RETURN result

with the above layout, you can write new code that tests for your criteria (either A or B return 5 or less)

measure A = 
VAR resultA = <your A code>
VAR resultB= <your B code>

RETURN if(resultA <=5 || resultB<=5,BLANK(),ResultA)