Forum Discussion
Show table only when value is selected
Hi Everyone, I'm looking to make a table show only data when a value is highlighted from another table. By default I only want to show a single table which when selecting a single ID, shows the hi...
Hi Slayer,
The ID's are the same field so the Is not Blank does not work for me. I've been able to solve the issue myself though:
Highlight check =
IF ( SELECTEDVALUE ( FACT[ID] ) = ALLSELECTED ( FACT[ID] ), 1, 0 )
The logic applies as follows:
I'm using an IF statement to check the selected value from the Top table against the ID's being shown in the bottom table (ALLSELECTED). If true then 1 else 0.
I then filter the table based on the measure and say that the measure has to equal 1.
The only problem I have right now is that the IF statement returns an error when there is no value selected. That part still needs solving
Try to use
IF ( ISFILTERED( FACT[ID] ) ,1,0)
It worked for me.