Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Filtering using counting in a Radar

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

TypeCount
X2
Y2
Z1

Where Count is defined as below

 

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

 

 

 

TableProducts

ProductType list
AX, Y
BX
CY
DZ

 

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?

 

 

 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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

  • AlB's avatar
    AlB
    Community Champion
    6 years ago

    Hi Anonymous 

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

    Cheers

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

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

       

      • AlB's avatar
        AlB
        Community Champion
        6 years ago

         

        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