Table matrix default

[Anonymous]

Hi,

Is it possible to have a table to display blank on default when nothing is selected?

It runs off a table above to display data when selected, but when a user first accesses and hasnt clicked, I'm hoping to have no data.

Thanks

Liam

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You could use ISCROSSFILTERED() or ISFILTERED() if fact table has relationship with slicer table.

Measure =
IF(ISCROSSFILTERED('Table (2)'[Column1]),1,0)

Then set rules in filter pane to show data whose measure = 1.

If no relationship, you could use SELECTEDVALUE() to compare values.

[amitchandak]

try adding a measure that uses isfiltered

https://docs.microsoft.com/en-us/dax/isfiltered-function-dax