Forum Discussion

Kames_Chia's avatar
Kames_Chia
Frequent Visitor
2 years ago
Solved

Two table visuals - second table visual shows blank if no selection made in first table visual

In my report, there are two table visuals.   1. Primary_table = Show the incident's key details (such as Incident number and total processing time) 1. Secondary_table = based on row selection on p...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Kames_Chia ,

    I create two tables as you mentioned.

    Then I create a measure and use it in a card visual.

    Measure = 
IF (
    COUNTROWS ( ALLSELECTED ( Primary_table ) )
        = COUNTROWS ( ALL ( Primary_table ) ),
    BLANK (),
    1
)

    When I click on the slicer, it will  get what you want.

     

     

     

    Best Regards

    Yilong Zhou

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Kames_Chia ,

I create two tables as you mentioned.

Then I create a measure and use it in a card visual.

Measure = 
IF (
    COUNTROWS ( ALLSELECTED ( Primary_table ) )
        = COUNTROWS ( ALL ( Primary_table ) ),
    BLANK (),
    1
)

When I click on the slicer, it will  get what you want.

 

 

 

Best Regards

Yilong Zhou

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