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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
benitoski
Regular Visitor

Create a visual table from another visual table

I need to create a table object by capturing the results of another table object.
Screenshot of the report:

 

benitoski_0-1676985794454.png

 

The report has two slicers where the user selects both Occurrence and Class
The table object has two fixed filters (not accessible to the user): Indicator and KPI.
The table object displays (distinct) count for each id.
Results change dynamically based on the filters available to the user

 

What I need is to create a table object with the following result:

 

Count_of_OccurrenceCount_of_Id
42
21
11

 

Is it possible to do this in Power BI?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@benitoski , I think this is a case of dynamic segmentation

 

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@benitoski , I think this is a case of dynamic segmentation

 

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak Thank you very much, this is exactly what I was looking for!

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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