Details table in same page

[icarbajals]

Hi everyone,

I have a report with 2 schemas related through an ID_document. The first schema has the totals and the second has the details to drill down them.

I want to display one table using the totals_schema and a second table that remains empty until the user select a value (without using slicer visual) and then get the data from the details_schema.

I wasn't able to get the second table empty, waiting for the the user to select a value. Is this possible to achieve? Or do I need to use the "drill thru page" concept?

Thanks in advance

[amitchandak]

@icarbajals , You can create a measure based on selectedvalue of one of more column and use that as visual level filter

int(calculate(isfiltered(Table[Column]) , allselected()) )

or

int(calculate(isfiltered(Table[Column]) || isfiltered(Table[Column2]) , allselected()) )

Check for value =1 for the above measure in the visual level filter of details

refer video from Guyinacube

https://www.youtube.com/watch?v=sXn-QZqLD-8