Forum Discussion
paulalmond91
Helper II
Helper IIIssue with totals on SUMX with GENERATE function
I have a calculation that determines the total value of a sale that falls inside a single month. There is an added complication in that I require this calculation to divide its total between the numb...
- paulalmond91,
Try this and see if it works (I’m assuming your date table has a month column):
Totals = SUMX(SUMMARIZE(‘Date’, Date[Month]), [Optimised Spread])
(Apologies if there is a bracket missing or some other syntax error; I’m typing this on a phone...)
paulalmond91Helper II
Helper IIThanks for this.
I did review the details but none of the suggestions seemed to help in my scenario.
This is because the filters are generated by the GENERATE function and there are no slice filters being applied.
PaulDBrown
Community Champion
Community Championpaulalmond91,
Try this and see if it works (I’m assuming your date table has a month column):
Totals = SUMX(SUMMARIZE(‘Date’, Date[Month]), [Optimised Spread])
(Apologies if there is a bracket missing or some other syntax error; I’m typing this on a phone...)
Try this and see if it works (I’m assuming your date table has a month column):
Totals = SUMX(SUMMARIZE(‘Date’, Date[Month]), [Optimised Spread])
(Apologies if there is a bracket missing or some other syntax error; I’m typing this on a phone...)
- paulalmond91
This is perfect!
Thank you so much!