Forum Discussion

Nigelbloomy's avatar
Nigelbloomy
Frequent Visitor
5 years ago
Solved

Count with second column

I have 3 columns (Investment, Investment Status, and Line Item Detail).  I need a DAX measure (I don't have access to the dataset) to see if an investment has more than one status.   Investment ...
  • wdx223_Daniel's avatar
    wdx223_Daniel
    5 years ago

    Measure=CALCULATE(DISTINCTCOUNT(Sample[Investment Status]),ALLEXCEPT(Sample,Sample[Investment]))

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
5 years ago

Measure=CALCULATE(DISTINCTCOUNT(Sample[Investment Status]),ALLEXCEPT(Sample,Sample[Investment]))

  • Nigelbloomy's avatar
    Nigelbloomy
    Frequent Visitor
    5 years ago

    That works  Thank you!  That was much simpler than the path I was headed down.