Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Count the Machines with Single Status

Hi Friends,   I am trying to do a calculation and stuck since I am new. Below is the list of machines. If you can see Machine 1 is having Fixed as well as Open status entries. I want to calculate o...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    Hi  Anonymous ,

     

    Create a measure as below:

    Measure = 
var _tab=CALCULATETABLE(VALUES('Table'[Status]),FILTER(ALL('Table'),'Table'[Machine Name]=MAX('Table'[Machine Name])))
Return
IF("Open" in _tab,BLANK(),1)

    Add the measure to the filter pane and select measure is 1,and you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

jppv20's avatar
jppv20
Solution Sage
4 years ago

Hi Anonymous ,

 

You can create a new column using this:

 

Status2 = IF(CALCULATE(MAX(Machines[Status]),ALLEXCEPT(Machines,Machines[Machine Name]))<>"Open","Fixed","Open")
 
Result:

 

If you put it in a table you will get this:

 

Jori

 

If I answered your question, please mark it as a solution to help other members find it more quickly.

Connect on Linkedin