Forum Discussion

lawada4's avatar
lawada4
Frequent Visitor
3 years ago
Solved

total sum value in table visual is wrong

im trying to calculate the total commission by all salespersons. i have 2 tables , one table shows the commission by catgory and the other table shows sales transactions by salespersons.   i create...
"Need Help"
@Daxhelp
@get help
@Please Help
Help
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi lawada4 

    please try

    Total Commission =
    SUMX (
    SUMMARIZE (
    'categories trans',
    'categories trans'[AGENT_NAME],
    'categories trans'[Category]
    ),
    CALCULATE ( SUM ( 'categories trans'[Commission] ) )
    )

ValtteriN's avatar
ValtteriN
Community Champion
3 years ago

Hi,

This is a quite common issue. I recommend reading this article to understand the cause of it: Obtaining accurate totals in DAX - SQLBI

Additionally it is generally speaking not a good idea to have a "both" directions realtionship between your tables. Try to change the realationship to "single" between your tables. Additionally if you just want to have total disregarding filters use ALL in your dax. E.g. CALCULATE(SUM(Table[column]),ALL(Table))

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/