Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need help in DAX!!

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!

 

3 Replies

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi Anonymous 

    Perhaps 

    f= [d]/[e]

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      tamerj1 still it is crossing % more than 100

      • v-jingzhang's avatar
        v-jingzhang
        Icon for Community Support rankCommunity Support
        3 years ago

        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.