Forum Discussion
Locking Values on a denominator DIVIDE formula
Hi GeraldGEmerick.
Happy for your reply.
In fact after searching a little bit further i found a similiar solution that goes by this:Total Registered Processes =CALCULATE(DISTINCTCOUNT(Results[NUP]),ALL(Results),VALUES(Resultados[Planned]))
You can also found a similiar situation via this link:
https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/with-static-denominator/m-p/4675151
Thank you for your response,
Best RegardsHi DVD_RDRGES,
Thank you for your follow-up and for outlining the solution you implemented.
Your approach using ALL(Results) with VALUES(Results[Planned]) is correct, as it ensures the denominator remains unaffected by visual interactions while honoring the Planned filter context.
This keeps your measure tied to the total planned processes and allows for scalability as new records are added.
To clarify:
Numerator ([Registered Processes]) adapts to slicers and visual interactions.
Denominator ([Total Registered Processes]) stays fixed to the full set of planned processes, ensuring a consistent percentage calculation.
This setup matches the scenario you described, and your measure now accurately supports your percentage logic requirements.
Thank you.
Hi GeraldGEmerick.
Happy for your reply.
In fact after searching a little bit further i found a similiar solution that goes by this:
You can also found a similiar situation via this link:
https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/with-static-denominator/m-p/4675151
Thank you for your response,
Best Regards