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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

Distinct Count - Calculated table



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 

"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) 



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?




Super User
Super User

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

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.