Display table text only if ALL values in a group are selected

[Anonymous]

Hi, I have two data tables that I'm working with, called 1_Main_Data and 1_Text_Data. I'd like to connect 1_Main_Data and 1_Text_Data.

The tables looks like this:

1_Main_Data:

Value Type (group)	Value Type	Date	Value
Revenue	Revenue Stream 1	12/31/2021	100
Revenue	Revenue Stream 1	3/31/2022	110
Revenue	Revenue Stream 1	6/30/2022	115
Revenue	Revenue Stream 2	12/31/2021	700
Revenue	Revenue Stream 2	3/31/2022	710
Revenue	Revenue Stream 2	6/30/2022	720
Revenue	Revenue Stream 3	12/31/2021	5
Revenue	Revenue Stream 3	3/31/2022	20
Revenue	Revenue Stream 4	6/30/2022	25
Balance	Account 1	12/31/2021	1000
Balance	Account 1	3/31/2022	1200
Balance	Account 1	6/30/2022	1300
Balance	Account 2	12/31/2021	2000
Balance	Account 2	3/31/2022	3000
Balance	Account 2	6/30/2022	3400

1_Commentary_Data:

Value Type (group)	Forecast Start Period	Text
Revenue	12/31/2021	Stream 1 grew at 5 units per quarter
Revenue	12/31/2021	Stream 3 had highest percentage growth
Revenue	12/31/2021	No revenue Streams had negative values
Balance	12/31/2021	Account balances grew
Balance	12/31/2021	Account 2 had largest percentage growth

So, both of these tables contain data pertaining to revenues and account balance forecasts. The forecasts begin on the Forecast Period Start Date and continue until 6/30/2022. The 1_Commentary_Data table contains a text column that will be used to display some commentary in a table/matrix. 

I have a slicer that shows Value Type (Group) first and then Value Type. These slicer variables are coming from 1_Total_Data. What I want is for the commentary to show up when I select ALL values of a particular Value Type (Group). So, it should be blank if I only select Revenue Stream 1, but if I select Revenue Stream 1, 2, and 3, then it should show all of the Text values in 1_Commentary_Data in a table or matrix.

How can I do this? I don't understand how these tables could be linked in the data model, becuase Revenue or Balance is showing up on every row of Value Type (group), so any selection of a value in that group will give the table the greenlight to show the Text Values. I've also tried a measure, but that won't allow me to pass a table of values to the Table or Matrix visualizations.

Is there any way to do what I want? I would appreciate any insight on this problem. Thank you!

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please try below steps

1. my test table 

Table:

Table2:

Model:

2. add two slicer visual and add two fields from "Table"

3. create a measure and add it to card visual

Measure =
VAR cur_valuetype_group =
    HASONEFILTER ( 'Table'[Value Type (group)] )
VAR cur_valuetype =
    HASONEFILTER ( 'Table'[Value Type] )
VAR tmp =
    FILTER (
        ALL ( 'Table 2' ),
        cur_valuetype_group = TRUE ()
            && cur_valuetype = FALSE ()
            && 'Table 2'[Value Type (group)] = SELECTEDVALUE ( 'Table'[Value Type (group)] )
    )
RETURN
    CONCATENATEX ( tmp, [Text] & ";", "
" )

Please refer the attached .pbix file.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.