How to Configure a Slicer to Control the Denominator of a Calculated Field?

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please try:

Count = CALCULATE(COUNTROWS('Table'),'Table'[No.of Machines Running]>0)

Average = CALCULATE(AVERAGE('Table'[MTTF]),'Table'[No.of Machines Running]>0)

Output:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[amitchandak]

@Anonymous , Based on what I got so far, you can use bookmarks and buttons

Bookmarks
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks