Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
89 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
96 | |
92 | |
91 | |
75 | |
69 |