Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I am getting an incorrect measure result when dividing negative numbers (churn actual vs budget). I used this formula as my measure:
% Monthly Churn Budget = SUM('2017 Churn Reasons'[MRC Amount])/CALCULATE(SUM('Monthly Churn Budget'[Churn Budget]))
I did essentially the same thing for sales actual vs budget and got correct percentages, but it is not working for churn. As you can see in the photo below the percentages are not correct.
I am fairly new to this but have researched a lot of posts so I really apologize if this has been solved elsewhere.
Thank you!
I Have the same problem.
this is the dax I'm usign:
HI @krp1317,
It will be help, if you provide more detailed contents and sample data.
Regards,
Xiaoxin Sheng
User | Count |
---|---|
97 | |
87 | |
78 | |
74 | |
70 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |