Assistance with the calculation, excluding certain values

[Uzh17]

Hello, I need help with a formula that will filter a condition: if the value is less than 150, it should not be included in the calculation.
What do I have now:
1

And what is needed:

2

How is availability calculated

Availability = SUMX(Values(Customers[Customer]), CALCULATE(([TesterRunTimeHrs] + [Ava_Handling_ODB])) / SUM('Shift report'[Run]))

Thank you.

[Anonymous · Accepted solution]

Hi @Uzh17 ,

What about adding a filter to the visual?

Add a filter to a report in Power BI - Power BI | Microsoft Learn

For example, this is the table visual contains the value which is less than 150.

After the filter is added, the values are greater than 150.

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.           

[Anonymous · Accepted solution]

Hi @Uzh17 ,

What about adding a filter to the visual?

Add a filter to a report in Power BI - Power BI | Microsoft Learn

For example, this is the table visual contains the value which is less than 150.

After the filter is added, the values are greater than 150.

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.           

[Uzh17 · Accepted solution]

Hi, I found other solution. Thanks for you time and help.

[nirali_arora]

Firstly create a measure of sum of 1st tests and use the formula 

Availability = filter(Values(Customers[Customer]), [sum of 1st tests] > 150), CALCULATE(([TesterRunTimeHrs] + [Ava_Handling_ODB])) / SUM('Shift report'[Run]))