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 except the one affected by the selected filter (it should return the value 1).

How can I fix this?

Thanks for your help

 

 

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

2 Replies

  • 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