topic Filtering total Run hours by status Running and or Not Running in DAX Commands and Tips

Filtering total Run hours by status Running and or Not Running

goatman — Wed, 10 May 2023 05:56:10 GMT

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.

Runnining Pumps(measure) =

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

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"

Re: Filtering total Run hours by status Running and or Not Running

Anonymous — Fri, 12 May 2023 06:41:20 GMT

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.

Re: Filtering total Run hours by status Running and or Not Running

goatman — Fri, 12 May 2023 07:35:21 GMT

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