Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello All,
I'm trying to create a sum based on 2 different category measures. "Forecast Status" and "Status" and it's not showing me the total. Please help, Thanks in advance for any assistance.
Hi @bo_wang5
Is [Sum Won Q3] a measure?
BTWTry this:
In forecast and won = SUMX(filter(Data,Data[Forecast Status]="in forecast"&&Data[Status]="won"),[Sum Won Q3])
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Thank you so much for responding.
Yes that is correct [Sum Won Q3] is a measure, it is calcuated as
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |