Help need to get the TOTAL calculation correct - when subtracting two fields

Hey ashmitp869 ,

this happens when a measure is evaluated with a filter from the row, but this filter is not present on the total line.

To really help you it's important to understand

• the measure that creates the 2118
• more or less the semantic model

You can try this

This claim total =
sumx('<the table that contains the column linenumber>',
[the measure that creates the 2118]
)

If this does not help to tackle your challenge, provide a pbix that contains sample data but still reflects your semantic 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 as well. Do not forget to describe the expected outcome based on the sample data you provide.

Regards,

Tom