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!
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.
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 |
|---|---|
| 64 | |
| 51 | |
| 46 | |
| 23 | |
| 19 |
| User | Count |
|---|---|
| 135 | |
| 110 | |
| 50 | |
| 31 | |
| 29 |