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]),...
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.