Forum Discussion
SUM not working
Hello, I cant figure out why my total sum is not working, its giving a really werid number. I want to filter based on month, etc... and see the total sum of NSR, double checked everything and ...
Hi, Anonymous
You can use Dax calculations in Desktop.
Sample data:
Measure:
SUM = SUMX('Table',[Value])Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Which column from which table did you use for the SUM of NSR Per Day? Which table and column is your date from. While I can see the relationships between the tables, I can only imagine which columns are use to the create the relationships. This is a good read on how you can get a better response: