View Data in table 2 only when something in table 1 is selected.

[Benc7777]

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

[adudani · Accepted solution]

hi @Benc7777 ,

 if you want the product orders table to filter the order details:

select the product orders tables

1. click on "Format"

2. click on "Edit interactions"

3. click on "Filter"

this will enable the filtering.

let me know if this is resolved.

[johnt75 · Accepted solution]

My mistake, HASONEVALUE was never going to work.Try

Single Order Selected = IF( COUNTROWS( ALLSELECTED( 'Query1'[Order Number])), 1 )

[Benc7777]

Hi @adudani,

Many thanks for taking the time, yes the part works, but I dont want the order details to show anything unless something is selected within the Future Orders table.

[johnt75]

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.

[Benc7777]

I have tried that but i think ive done something wrong its not changed ?

[Anonymous · Accepted solution]

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 Zhou

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

[Benc7777]

@AnonymousYou sir have won the internet today, this worked perfectly. I really appriciate your help.

I also appriciate @johnt75 and @adudani for their inputs too.

Really helped me guys, thanks.

I will no doubt be back to ask more questions of the godly like skills of this helpful forum very soon.

Have a great weekend

B

[johnt75 · Accepted solution]

My mistake, HASONEVALUE was never going to work.Try

Single Order Selected = IF( COUNTROWS( ALLSELECTED( 'Query1'[Order Number])), 1 )

[adudani · Accepted solution]

hi @Benc7777 ,

 if you want the product orders table to filter the order details:

select the product orders tables

1. click on "Format"

2. click on "Edit interactions"

3. click on "Filter"

this will enable the filtering.

let me know if this is resolved.