Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Get DistinctCount of ColumnB based on ColumnA

Need help to get DistinctCount of ColumnB (ServiceVisitYr) based on ColumnA (ServiceAddress)   ServiceAddress ServiceVisitYr A1 2017 A1 2017 A1 2018 A1 2019 A1 2019 A2 2...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago
    Measure = CALCULATE(DISTINCTCOUNT('Table'[ServiceVisitYr]),ALLSELECTED('Table'[ServiceVisitYr]))
Anonymous's avatar
Anonymous
Not applicable
6 years ago
CALCULATE(DISTINCTCOUNT(Test[ServiceVisitYr]),ALLEXCEPT(Test,Test[ServiceAddress]))
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for your answer.

 

Your solution works in the data set presented above.

 

The other problem is I'm using slicer on 

ServiceVisitYr
and when I filter data I do not get correct count
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Measure = CALCULATE(DISTINCTCOUNT('Table'[ServiceVisitYr]),ALLSELECTED('Table'[ServiceVisitYr]))