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!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi,
Is there a way to do a distinct count over a calculated "on the fly" table? I got this measure:
That feeds this table:
Where through bookmarks Im filtering the records:
But now the user is asking to get the distinct count for all those displayed "Systems". If I use a distinct count
but it does not allow me to made opperations over that table.
Does any one knows how could I use that table? or any other suggestion?
You cannot measure a measure. Reimplement the complete logic inside a single measure.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 61 | |
| 59 | |
| 42 | |
| 18 | |
| 15 |
| User | Count |
|---|---|
| 108 | |
| 100 | |
| 39 | |
| 29 | |
| 29 |