Filtering using counting in a Radar

[stchln]

Hey,

I am trying to make a report including a Radar visual using TableRadar and I would like to display from another table TableProducts a list of rows that match the selection so that user can see details.

TableRadar

Type	Count
X	2
Y	2
Z	1

Where Count is defined as below

Count = CALCULATE(COUNT(TableProducts[Product]);FILTER(TableProducts;SEARCH([Type];TableProducts[Type list];;0)))

TableProducts

Product	Type list
A	X, Y
B	X
C	Y
D	Z

As 'Type list' is made of a list of tags, I cannot create directly a relationship between the two tables so that a selection done in Radar can directly display list of rows. Any idea?

[AlB]

Hi @stchln 

Can you explain a bit more what exactly you would want to have as final result? It is not quite clear

Cheers

[stchln]

When I click on the point x in the radar visual, I would like to see rows A and B displayed in TableProducts.

[AlB]

1. Eliminate the relationship

2. Create any of these two measures below ( the first one show all rows when nothing is selected in the radar, the second one shows nothing in that case)

3. Use the measure to filter the visual with TableProducts (show when result of the measure is 1)

ShowMeasure =
IF(
    SEARCH(
        SELECTEDVALUE( TableRadar[Type] );
        SELECTEDVALUE( TableProducts[Type list] );
        1;
        0
    ) > 0;
    1;
    0
)

ShowMeasure2 =
IF (
    COUNT ( TableRadar[Type] ) = COUNTROWS ( ALL ( TableRadar[Type] ) );
    0;
    IF (
        SEARCH (
            SELECTEDVALUE ( TableRadar[Type] );
            SELECTEDVALUE ( TableProducts[Type list] );
            1;
            0
        ) > 0;
        1;
        0
    )
)

Please mark the question solved when done and consider giving kudos if posts are helpful.

 Cheers 

[stchln]

Should I create one column per possible Type and then create several relationships?