Hide a matrix visual unless a field is filtered

[Alocin]

Hi all, I am a newbie with Power BI - only started a few weeks ago, so please excuse me if I'm asking basic questions.

I have a matrix visual that displays percentages of counts. I want to ensure this matrix is hidden unless a filter is applied to a particular field (controlled by a splicer). The reason is that if more than one item is selected in the matrix, the percentages are calculated per total count, not count per item. So to avoid people reporting 'fake' percentages', I want to hide the table unless only one item is selected. I created a measure as follows:

Measure = int(isfiltered('TableName'[FieldName]))

Then on the matrix visual I added a filter as follows:

 

This does not work at all - it appears to be ignored completely. However when I do the exact same method (same measure, same filter, same splicer) to a column graph, the column graph is blank unless a value in the splicer is selected. But somehow it doesn't work on a matrix?

Important to note that all the data is from one table - data for matrix, graph, splicer all from the same table. So no relationship issues should be at play. The matrix has 2 field in Row, and 1 field in column.

i would appreciate some help!

[Idrissshatila · Accepted solution]

Hello @Alocin ,

try this measure:

Measure = CALCULATE(
    int(ISFILTERED(TableName[column_name])),
        ALLSELECTED(TableName[column_name]))

[Alocin]

Thank You! this worked perfectly!

[Ritaf1983]

Hi @Alocin 
See my solutions in the linked posts included attached to them PBIX. Both use the same logic, creating DAX to test user choices and manipulate conditional formatting. 

https://community.fabric.microsoft.com/t5/Desktop/Powerbi/m-p/3615548

https://community.fabric.microsoft.com/t5/Desktop/Show-and-Hide-image-based-on-slicer-selection/m-p/...

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