Forum Discussion

icarbajals's avatar
icarbajals
New Member
4 years ago

Details table in same page

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

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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