Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am try to get the total of won-existing enquiries in my budget table.
I am trying to split out my contracts that have been Won. What is happening with the code below, it isn't summing up correctly. It is always short of my expected result into my Budget table. If I sum the enquiries on their own, everything adds up correctly.
My question, is there a command (ie. groupby, groupon,...?) that will insure that my data is lined up before it is Sumx'd? Below is the existing code that isn't working. Any help would be great.
Won-Existing =
SUMX (
FILTER ( _enquiries,
_enquiries[_GUID] = _2018_Budget[_GUID] && _enquiries[statuscode] = 866120005
),
_enquiries[Amount (Enq)]
)
Solved! Go to Solution.
Hi @Anonymous,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please share some data sample and your desired output.
Best Regards,
Cherry
Hi @Anonymous,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please share some data sample and your desired output.
Best Regards,
Cherry
Hey,
w/o knowing how both tables "_enquiries" and "_2018_Budget" are related, if ever, it will not be possible to provide you wiht any advise.
Please consider to create apbix with sample data, upload the file to onedrive or dropbox and share the link.
You can also check this pattern https://www.daxpatterns.com/handling-different-granularities/ and also this one https://www.daxpatterns.com/budget-patterns/
Regards,
Tom
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |