Measure Total isn't outputting the Total sum?

[lyfe0fedd]

I have a measure Commission = [Qty]*[Comm fixed 40%]

what it's doing is multiplying the Total Qty and the Total 40% but what I want it to do is just calculate the sum of all commission figures which is $6,154.61, not $63,682.8

[TomMartens]

Hey @lyfe0fedd ,

create a pbix file containing sample data that still reflects your data model (tables, relationships, calculated columns, and measures). Upload the pbix to OneDrive, Google Drive, or Dropbox and share the link. If you are using a spreadsheet to create the sample data instead of the manual input method, share the Spreadsheet file as well.

Explain the expected result based on the sample data you provide.

Regards,

Tom

[lyfe0fedd]

Book.xlsx - Excel Data Set for Power Bi

PowerBI link - https://app.powerbi.com/links/RWRNY9uZZj?ctid=32dfd67c-42d4-473b-8b85-ecf9779aa69f&pbi_source=linkSh...

not sure if this is helpful but essentially I have linked the Sales-Cash and Commission by the Item Name

[TomMartens]

Hey @lyfe0fedd ,

you have to leverage a table iterator function like SUMX, your measure will then look like this:

the measure = 
SUMX(
    '<the table>'
    , [Qty] * [Comm fixed 40%]
)

I assume that [Qty],  [Comm fixed 40%] are measures.
If [Qty] is a column, then your measure might looks like this:

the measure = 
SUMX(
    '<the table>'
    , '<the table>'[Qty] * [Comm fixed 40%]
)

Hopefully, this helps to tackle your challenge.

Regards,

Tom

[lyfe0fedd]

Hi TomMartens, I've done that before but still didn't work. Not sure why the Total skews up