Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have 2 measures with numeric values. My end goal goal is to get a measure which gives me a % value of one over the other.
The 2 measures are:
1. Actual Losses Recovered (£)
2. Insured Loss Reserve
formula: Actuak losses recovered / insured loss Reserve
I'm using the following measure but this is giving me an average % which i don't want:
% of losses Recovered = DIVIDE ([Actual Losses Recovered], [Insured Loss Recovered],0)
I want the total sum of one column divided by the total suym of the other column which gives me the exact % value on my scorecard visual
Any help will be appreciated
Many thanks,
Jay
Solved! Go to Solution.
Use one of the following. Second one removes all filter applied to the table
% of losses Recovered = DIVIDE (SUM([Actual Losses Recovered]), SUM([Insured Loss Recovered]),0)
% of losses Recovered1 = DIVIDE (CALCULATE(SUM([Actual Losses Recovered]),ALL('Table')), CALCULATE(SUM([Insured Loss Recovered]),ALL('Table')),0)
Use one of the following. Second one removes all filter applied to the table
% of losses Recovered = DIVIDE (SUM([Actual Losses Recovered]), SUM([Insured Loss Recovered]),0)
% of losses Recovered1 = DIVIDE (CALCULATE(SUM([Actual Losses Recovered]),ALL('Table')), CALCULATE(SUM([Insured Loss Recovered]),ALL('Table')),0)
It works. Thank you so much 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.