Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
I need to create a table object by capturing the results of another table object.
Screenshot of the report:
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_Occurrence | Count_of_Id |
| 4 | 2 |
| 2 | 1 |
| 1 | 1 |
Is it possible to do this in Power BI?
Solved! Go to Solution.
@benitoski , I think this is a case of dynamic segmentation
Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ
@benitoski , I think this is a case of dynamic segmentation
Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 58 | |
| 53 | |
| 40 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 114 | |
| 107 | |
| 41 | |
| 34 | |
| 25 |