Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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] )
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |