Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Countrows / Filter --> Filter through another grap

Hi all, 

 

I need your help on the subject below. 

 

I have several measure which look like the measure below. I use them to count the number of products depending on filters. 

Number product type < 1 & commonality < 2 = 
COUNTROWS(
    FILTER('Table 1';
        'Table 1'[Type] = 1 &&
        [Commonality_measure] < 2)
)

 

Then I apply those measures to the tree map. And my problem is when I want to filter my matrix through the treemap, nothing happens like below. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Also I don't find how to attached my pbi 😞

 

Thanks a lot

Erwan

 

 

Need Help

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    We should add the product to the Group in treemap visual like that, Then we can filter the table visual.

     

    For more details, please check the pbix as attached.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi v-frfei-msft 

       

      Thank you for your answer. 

       

      I already tried this, but I have in reality 30 000 products, so when I add my field product in the real treemap, it is a real mess. 

       

      Is there another solution?

       

      Erwan