Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

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. 

 

1.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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

 

Thanks a lot

Erwan

 

 

2 REPLIES 2
v-frfei-msft
Community Support
Community Support

Hi @Anonymous ,

 

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

Capture.PNG

 

For more details, please check the pbix as attached.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Anonymous
Not applicable

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

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors
Users online (1,587)