Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Finding Duplicate Names with Different Status

Hi,    I have a requirement to showcase on a table employees who went from contractor to full time. How can I achieve this? Is there a DAX to create a count or highlight those names which converte...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    Create a measure like below and add it to visual filter then configure the condition formatting like below.

    Measure = CALCULATE(DISTINCTCOUNT('Table'[Status]),ALLEXCEPT('Table','Table'[Name]))

    Result would be shown as below.

     

    Best Regards,

    Jay

     

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

nandukrishnavs's avatar
nandukrishnavs
Community Champion
6 years ago

Anonymous 

 

Try this measure

 

contractortofulltime = 
var _isContractor= CALCULATE(COUNT('Table'[Status]),'Table'[Status]="Contractor")
var _isFulltime= CALCULATE(COUNT('Table'[Status]),'Table'[Status]="Full Time")
var _contractortofulltime = IF(_isContractor>0&&_isFulltime>0,"Yes","No")
return _contractortofulltime

 

 

Now you can apply this measure in visual level filter ( is Yes ). 

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

 

  • nandukrishnavs's avatar
    nandukrishnavs
    Community Champion
    6 years ago

    Anonymous  is it not working?