Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Distinct count does not work

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 hav...
Need Help
az38's avatar
az38
Community Champion
6 years ago

Anonymous 

try CALCULATE()

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

or even

MEASURE = CALCULATE(DISTINCTCOUNT(Table1[Col1]), ALLSELECTED(Table1))
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    amitchandak
    Super User
    6 years ago

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

    Appreciate your Kudos.