topic Re: Need help in DAX!! in DAX Commands and Tips

Need help in DAX!!

Anonymous — Mon, 10 Apr 2023 17:55:37 GMT

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!

Re: Need help in DAX!!

tamerj1 — Mon, 10 Apr 2023 18:00:48 GMT

Hi Anonymous

Perhaps

f= [d]/[e]

Re: Need help in DAX!!

Anonymous — Mon, 10 Apr 2023 18:26:51 GMT

tamerj1 still it is crossing % more than 100

Re: Need help in DAX!!

v-jingzhang — Wed, 12 Apr 2023 06:21:54 GMT

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.