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?