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]))