Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Create a metric that checks if a given code has different statuses

I have a field in the table that has 3 different status values. they are: ACCEPTED, EXPIRED and REFUSED. I want to check when the same provider whose assistance number has 2 or 3 different statuses,...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi Anonymous 

     

    You can create a new column with below DAX

    Column = IF(CALCULATE(DISTINCTCOUNT('Table'[Status]),ALLEXCEPT('Table','Table'[Provider],'Table'[Assistance number]))>1,"Yes","No")

     

    Or create a measure with the same code as above column. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Anonymous 

 

You can create a new column with below DAX

Column = IF(CALCULATE(DISTINCTCOUNT('Table'[Status]),ALLEXCEPT('Table','Table'[Provider],'Table'[Assistance number]))>1,"Yes","No")

 

Or create a measure with the same code as above column. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.