Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

DAX Error SUMX

Hi,    I'm working on a DAX and not getting the expected results. It seems that at a line item level it is calculating correctly however, at the total level it is not summing but performing the cal...
" Error Handling"
"DAX "
"Grand Total"
DAX SUMX
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, 

     

    I was able to find the solution. I was using SUMX on the connected tables but I needed to use it with a summarize on the table where the line item data is housed. He is what my code ended up looking like. 

     

    SUMX(SUMMARIZE(
        'WagesHomeCC and Fringe Line Items','WagesHomeCC and Fringe Line Items'[Date], 'WagesHomeCC and Fringe Line Items'[Cost Ctr]),
        IF(
            NOT(ISBLANK([Wages on Flat Units])),
            CALCULATE(
                SUM('WagesHomeCC and Fringe Line Items'[Amount]),
                Account_Map[Lvl 2] = "Total PR Tax"
            ),
            0
        )
    )
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,Anonymous  I am glad to help you.
Hello,Jihwan_Kim ,foodd .thanks for your concern about this issue.

May I ask if your problem is solved, and if so, you can mark the suggestions you found helpful as solutions or share the solutions you used, as this will help more users with similar problems.
If your problem is not solved, you can share a .pbix file via OneDrive that does not contain sensitive data, which will help solve your problem.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.