Distinct count does not work

[Anonymous]

Hello

I create a MEASURE = DISTINCTCOUNT(Table1[Col1]) and I display it in a card visual.

However, it does not show the number of the entries that appear in a filtered table visual that I have created. It displays the number of entries in the whole table.

How can I make it count only the displayed entries please?

Thanks!

[v-eachen-msft]

Hi @Anonymous ,

Could you please share your sample data and the expected result here if you don't have any Confidential Information? Please upload your files to OneDrive for Business and share the link here.

[az38]

@Anonymous 

try CALCULATE()

MEASURE = CALCULATE(DISTINCTCOUNT(Table1[Col1]))

or even

MEASURE = CALCULATE(DISTINCTCOUNT(Table1[Col1]), ALLSELECTED(Table1))

[Anonymous]

@az38 

Unfortunately it does not work. It keeps showing the total distinct count in the table and not the distinct count of the rows shown in the table visual.

Any idea?

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.