Forum Discussion

FinozAndrea's avatar
FinozAndrea
Regular Visitor
5 years ago
Solved

Error in distinctcount

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...
Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    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

Pragati11's avatar
Pragati11
Super User
5 years ago

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's avatar
FinozAndrea
Regular Visitor
5 years ago

It works,

 

thankyou very much!