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
        )
    )
foodd's avatar
foodd
Icon for Community Champion rankCommunity Champion
2 years ago

Hello Anonymous, and thank you for sharing a question with the Community.  Please remember to adhere to the decorum of the Community Forum when asking a question.

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then share a file’s URL.

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523/highlight/true#M607150

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.