Forum Discussion

CalebG's avatar
CalebG
Frequent Visitor
1 year ago
Solved

Total Amount not Accurate on Matrix

Hi! I was notified by one of our end users that the totals on a dashboard I created were ignoring certain rows. I checked it out and I'm currently at a loss because a lot of the columns correctly rol...
Need Help
  • CalebG's avatar
    CalebG
    1 year ago

    Hi! Sorry for the delay, I ended up finding a solution by using SUMX as a function in my calculation. This allowed all the fields to properly roll-up and calculate correctly. Thank you for all your help! 

    Invoice Total (Fixed) =
    SUMX(
        VALUES('Invoices on Contracts'[sch_contract]),
        CALCULATE(SUM('Invoices on Contracts'[Invoice Total w/o Tax])
    )
    )

     

FBergamaschi's avatar
FBergamaschi
Icon for Super User rankSuper User
1 year ago

Please include, in a usable format, not an image, a small set of rows for each of the tables involved in your request and show the data model in a picture, so that we can import the tables in Power BI and reproduce the data model. The subset of rows you provide, even is just a subset of the original tables, must cover your issue or question completely. Do not include sensitive information and do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided and make sure, in case you show a Power BI visual, to clarify the columns used in the grouping sections of the visual.

 

Need help uploading data? click here

 

Want faster answers? click here

CalebG's avatar
CalebG
Frequent Visitor
1 year ago

Hi! Sorry for the delay, I ended up finding a solution by using SUMX as a function in my calculation. This allowed all the fields to properly roll-up and calculate correctly. Thank you for all your help! 

Invoice Total (Fixed) =
SUMX(
    VALUES('Invoices on Contracts'[sch_contract]),
    CALCULATE(SUM('Invoices on Contracts'[Invoice Total w/o Tax])
)
)