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 All,
I am having an issue getting the correct %
in the main body of the calculations they dont seem right and the totals when I apply a filter, I dont understand why the % does not auto amend when applying the filter
I have 3 columns
1. Count DVS Referral = CALCULATE(count('Case'[CaseNumber]),'Case'[Eng_Request__c]="DVS Referral")
2. Count DVS Saved = CALCULATE(count('Case'[CaseNumber]),'Case'[call_type]<>"DVS Referral")
3. DVS Saved % = DIVIDE([Count DVS Saved],COUNT('Case'[Count DVS Referral]))*100
Pics Attached
Thank you in Advance
Solved! Go to Solution.
Hi @mjohnsonuk,
Both [Count DVS Referral] and [Count DVS Saved] seem to be calculated column. I would suggest you create measures instead.
Best Regards,
Dale
Don't times it by 100, just change the formatting of the measure in the modelling tab to a percentage and pick your decimal places from there
Hi @mjohnsonuk,
Both [Count DVS Referral] and [Count DVS Saved] seem to be calculated column. I would suggest you create measures instead.
Best Regards,
Dale
Thank you - I changed the calculations to sit in a "New Measure", then I used the formula:
DIVIDE( [value to divide] , [value total ] ) *100 as you would in a normal "excel" calculation and it works fine - although I dont seem to be able to get the numbers to decimal places - any ideas??
TIA
Don't times it by 100, just change the formatting of the measure in the modelling tab to a percentage and pick your decimal places from there
Hello, @mjohnsonuk
I think, your formula of DVS Saved % isn't correct not only totals - for December 2017 DVS Saved % = 9/89 = 10.11%
I think, correct formula below
DVS Saved % = DIVIDE( [Count DVS Saved], [Count DVS Referral] )
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.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |