Cascading tables - showing no results when 1st not selected

[tposzytek]

Hi!

I am trying to implement a solution, when the second table shows no data until something is selected in first table. Filtering of data in second table based in selection in first works fine thanks to relationship: when first is selected, second shows only related rows. But when not selected, shows everything.

However when following solution written here: https://community.powerbi.com/t5/Desktop/Visualisations-blank-until-something-selected-in-a-slicer/t... (and many similar posts) adding this measure to visual filters hides all data when nothing is selected in first table, but when something is selected, then second shows all rows, not just thos related. 

How to do it?

Regards,

Tomasz

[v-danhe-msft]

Hi @tposzytek,

Based on my test, it could work on myside:

Sample data:

Create 2 tables.

Create a measure and add to the Table 2

SlicerCheck = if(calculate(distinctcount([Item]),allselected(Table1[Item]))=1,"Y","N")

Set the filter condition and you can see the result.

I would suggest you test again. If issue persists, would you please share your pbix file if possible? Also you can test with our sample report on your side to see if the same issue occurs.

https://www.dropbox.com/s/6fry17eu4q6v7x3/Cascading%20tables%20-%20showing%20no%20results%20when%201...

Regards,

Daniel He

[tposzytek]

That is true, it should, however there is something with my report it doesn't. I manage it working when I selected the "Show items with no data" option in the table which I wanted to filter using the measure. Any idea why?

I cannot share my file with you and I am unable repeat that issue using your file.

Regards,

Tomasz

[v-danhe-msft]

Hi @tposzytek,

Could you have checked the version of Power BI Desktop(2.60.5169.4101 64-bit (July 2018))? I suggest you to update to the latest version and test again.

Regards,

Daniel He