Forum Discussion
View Data in table 2 only when something in table 1 is selected.
Afternoon / Morning all,
I hope somebody can help, so I have done my query in SQL, created table one, now I want to only see data in table 2 when something is select by clicking the line in table 1 ?
Is this even possible ? Ive been trying and searching but have not come up with a solution yet ?
I wondered if there was a kind person that was much brighter than me that could help ?
B
My mistake, HASONEVALUE was never going to work.Try
Single Order Selected = IF( COUNTROWS( ALLSELECTED( 'Query1'[Order Number])), 1 )Hi Benc7777 ,
I think johnt75's measure is correct in its thinking, but you need to add some comparisons for it to work.
Please try code as below.
Something is Selected = VAR _TotalCount = COUNTROWS ( ALL ( 'Query1'[Order Number] ) ) VAR _SelectCount = COUNTROWS ( ALLSELECTED ( 'Query1'[Order Number] ) ) RETURN IF ( _SelectCount >= 1 && _SelectCount < _TotalCount, 1 )Add this into visual level filter and set it to show items when value =1.
Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
You could create a measure like
Single Order Selected = IF( HASONEVALUE( 'Query1'[Order Number]), 1 )Add that as a filter to the details table visual and set it only show when the value is 1.
