Forum Discussion
Responsive ResidentHelp 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
Super UserHey 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
ashmitp869TomMartens Thanks for your help.
Will you able to help me in this query pls.