How to keep denominator fixed?

[David_Wong]

You need to use level-aware calculations with PRE_FILTER in your denominator.

Take a look at this post and let me know if it helps:

Divide 2 calculated fields in QuickSight derived from same column xyz

For this type of calculation usually you need to use LAC-W functions. You need to use PRE_AGG in the numerator and PRE_FILTER in the denominator. It’s covered in this video. I put the timestamp for you. [QuickSight Virtual Author Workshop Part 2] Another more recent video about level aware calculations: [2022 QuickSight Learning Series: Using Leverage Level Aware Calculations to work with data]