Error in distinctcount

[FinozAndrea]

Hello,

I have a problem with the following measure. It should return the number of distinct elements in the related field, excluding the BLANK () values. The measure works correctly in all fields except the one affected by the selected filter (it should return the value 1).

How can I fix this?

Thanks for your help

[Pragati11 · Accepted solution]

HI @FinozAndrea ,

Try adding a FILTER statement to your DAX along with ALL SELECTED, so that it considers all the filters coming from outside.

As you haven't pasted your DAX, I am trying to write a sample:

N Comp liv 4 = Calculate(DISTINCTCOUNT(tablename[column1]), FILTER(ALLSELECTED(tablename), tablename[column1] <> BLANK()))

Try using your tablename and column name in above dax.

Thanks,

Pragati

[FinozAndrea]

It works,

thankyou very much!