Filtering total Run hours by status Running and or Not Running

[goatman]

I am using table below to create graphs of Total run hours sliced or filtered by Running Pumps and Not Running Pumps. I have used variuos DAX expressions but dont seem to get it.

-I need to see pumps that are currently running with their cumulative running hours since installation as long as they are still running  or in service.
- I also need to see pumps that are no longer running and their cummulative run hours or achived life. 

I have used the following expressions but not yielding correct result.

1. 

    Runnining Pumps(measure) =

      CALCULATE(SUM('Multistage Pumps'[OP Hrs]),'Multistage Pumps','Multistage Pumps'[Status]="Running"&&'Multistage            Pumps'[Entry Date]>=TODAY()-5) +[2022-Legacy Hours]

2. 

Not Runnining Pumps =

    CALCULATE(SUM('Multistage Pumps'[OP Hrs]),'Multistage Pumps','Multistage Pumps'[Status]="Not Running"&&'Multistage Pumps'[Entry Date]>=TODAY()-5) +[2022-Legacy Hours]

- Days (Day) run to end of month

-I am using entry date >= today to get the current running pumps.

-Some pumps have legacy hours hence the add.

Would you please help slice the data using status-"Running" and Status- "Not Running"

[Anonymous]

Hi @goatman ,

You want to dynamically display the results that are running and not running, right?

Try the slicer.

Slicers in Power BI - Power BI | Microsoft Learn

You can modify it to the following measure and keep one.

    Runnining Pumps(measure) =

      CALCULATE(SUM('Multistage Pumps'[OP Hrs]),FILTER(ALLSELECTED('Multistage Pumps'),'MultistagePumps'[Entry Date]>=TODAY()-5) +[2022-Legacy Hours]....

Best Regards,

Stephen Tao

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

[goatman]

Hi @Anonymous ,

Thank you for the quick response. Unfortunately, when i try to excute the DAX command, i am getting an error

"A function 'FILTER' has been used in a True/False expression that is used as a table filter expression. This is not allowed."

and what do you mean when you say keep one, i dont seem to get it.

Kind Regards,

@goatman