Forum Discussion
Help needed for DAX rolling calculation
I always prefer to use the Sum function whenever I can, rather than counting something. To make sure we are getting the data and to make sure we are not missing something with counting, can you replace the CountRows function and replace it with Sum (Last60Days) and Sum(FutureMeeting)?
Also, do you have a unique Row Index for every line in the data? I know that sometimes, without a Unique Index/Key/RowID, counting Rows can be problematic.
Let me know what you get.
Nate
I tried it and I got this. Looks like the account name and their totals are accurate, just the overall quota seems way off. It's not totaling correctly
Check the settings of your value field, and make sure that some weird setting isn't checked.
Everything looks ok.
Completed60 = sum('Invoked Function'[Last60Days])
PlannedFuture = Sum('Invoked Function'[FutureMeeting])
Last60Days = (IF(AND([Date] >= [Today]-60, [Date] <= [Today]),1,0))
FutureMeeting = If([Date]>Today(), 1,0)
Is there a way just to not show the Total at all?
you should be able to just check the menu item from above that states "Don't Summarize".
Now it's just saying 1 or 0 for each one. saying "true" or "false" that they had that type of meeting in the past 60 days.
I think I have to change the formula in for
Last60Days = (IF(AND([Date] >= [Today]-60, [Date] <= [Today]),1,0))
FutureMeeting = If([Date]>Today(), 1,0)
Like it meets the Date condition, something like count it, instead of true/false. Any ideas on the type of formula to use? Thanks!