Forum Discussion
Assistance with the calculation, excluding certain values
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
Thank you.
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.
- Hi, I found other solution. Thanks for you time and help.
3 Replies
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]))
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.
- Hi, I found other solution. Thanks for you time and help.
