Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 ...
Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dates filtering comes from Date (date per record submitted by user and stored in Dataverse) and the NSR per day from calculated column 

 

 

 

 

 

danextian's avatar
danextian
Super User
3 years ago

It is hard to figure out what is wrong with just the information  you provided. What you're showing is the formula in PQ but the sum formula could be different in DAX. Can you please post a sanitized version of the data model? Here's how you can get a quicker/better response: https://community.powerbi.com/t5/Desktop/bd-p/power-bi-designer 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Sorry, 

     

    I am super new to PowerBI and im not exactly sure what data you need to help me. The SUM formula created itself, where I can find the formula ?? 

     

    Heres my relationships between tables. I consolidate all of it in the NSR table (the last one). 

     

     

    Data sample looks liket this:

     

    Dates are in this format: 

     

    and the NSR is what I show you in my previous post, its calculated in Power Query based on other (type number) data. 

     

    What more can I show you to make it easy for you please??