Having one matrix blank until a category is selected from another matrix

[Anonymous]

I've forgotten how to do this but I'm sure I've done it before, ages ago.

I have a matrix that shows Level 1 [Function] and total cost.

I have a second matrix which shows [Sub-Function] and total cost.

Selecting a Function from the first matrix, naturally filters the second.

I want the second matrix to be blank until someone selects a Function from the first.

I've seen a function online which doesn't work.

IF(CALCULATE(DISTINCTCOUNT('Data'[Function]),ALLSELECTED('Data'[Function]))=1,"Y","N")

Any ideas?

[v-eachen-msft]

Hi @Anonymous ,

You could try ISFILTERED() or ISCROSSFILTERED() function. If you have found your previous solution, you could accept your own reply.

[Gordonlilj]

Hi,

Not sure if its exactly what you're after but you one way could be to create a measure like below

Measure = IF(ISFILTERED('Table'[Function]),1,0)

Then to add the measure as a visual filter and set it like below

 

[Anonymous · Accepted solution]

I actually just managed to locate the report I had done it in previously - I used

Total = IF(HASONEFILTER('Data'[Function]),'''Measures'[Total],BLANK())