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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
AndresSantosRey
New Member

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.