Forum Discussion
How to show % over total Policy Count?
Hi,
I have a data like below:
and using below DAX for % calculation:
Premium % Over within 10 Days SLA =
var vSLA = DIVIDE(
SUM('Consumer SLA'[BOOKED_PREMIUM_GBP_WITHIN_10_DAYS_SLA]),
sum('Consumer SLA'[POLICY_COUNT_TOTAL])
)
return
vSLA
but when I use it in KPI it looks like below:
What is the wrong with it? Please help me on this.
1 Reply
- MohammadLoran25
Solution Sage
Hi
Your question is not clear. What is your desired result?
Please send it in excel format or sth similar
Thank you
