SUMX Q

[Anonymous]

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

[v-piga-msft · Accepted 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

[TomMartens]

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