Need help in DAX!!

[Anonymous]

Hi everyone. I am trying to calculating a  % column using  measures below:

e = DISTINCTCOUNT(account_onboarding[ACCOUNT_ID])

d = calculate(DISTINCTCOUNT('myzones details'[user_AuthenticatedId]),filter(Account,Account[ACCOUNT_STATUS] = "Active"))

f= [e]/[d]

But i am getting the below result as:

I want to show the percentage in 100% itself but it is crossing 100%. Is there any way to fix it? Any help would be much appreciated. Thanks in Advance!

[tamerj1]

Hi @Anonymous 

Perhaps 

f= [d]/[e]

[Anonymous]

@tamerj1 still it is crossing % more than 100

[v-jingzhang]

Hi @Anonymous 

Can you display measures [e] and [d] in the same matrix visual, and check whether both of them return correct results on Sales Regression row? The [e] value on that row is greater than [d] value so the [f] result is above 100%. Check whether [e] or [d] is getting correct result on that row. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.