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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Anonymous
Not applicable

Distinct Count - Calculated table

Hi, 

 

Is there a way to do a distinct count over a calculated "on the fly" table? I got this measure:

AndresSantosRey_1-1680208520499.png

 

That feeds this table: 

AndresSantosRey_2-1680208673066.png

Where through bookmarks Im filtering the records:

AndresSantosRey_3-1680208770834.png

But now the user is asking to get the distinct count for all those displayed "Systems". If I use a distinct count 

"cntDistinctSystem = DISTINCTCOUNT(V_FCT_DIMENSION_MEASURE[SYSTEM_SK])" it gives me the correct value, but I need to put that measure in that same table, when I try to put it in a card it does not have the context. 
 
I tried to create a new measure replicating the process (create the table with the label base on the score, filter by the specific score and then counting the distinct systems) 
AndresSantosRey_5-1680209484210.png

 

AndresSantosRey_4-1680209321328.png

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?

 

 

 

1 REPLY 1
lbendlin
Super User
Super User

You cannot measure a measure.  Reimplement the complete logic inside a single measure.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

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