Forum Discussion
Hide Dynamically datas in a matrix
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 i...
MattAllington
Community Champion
Community ChampionMy 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)