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

[ashmitp869]

Hi All,

Can anyone help me with the Total Value for the Field This Claim Total.

It should be 2118 . But its doing the sum (TotalClaim) - Sum(BilledToDate).

How can I only get the sum (This Claim Total) Column in Total ?

Trying this but unable to find the epression .

This Claim Total =

VAR ThisClaim =

IF([BilledToDate] > 0, [TotalClaim] - [BilledToDate],BLANK())

RETURN

IF(HASONEVALUE(PayItem[Description]),

    ThisClaim, 

IF([BilledToDate] > 0, [TotalClaim] - [BilledToDate])

)

Thanks

[TomMartens]

Hey @ashmitp869 ,

no, I can't.

Regards,

Tom

[TomMartens · Accepted solution]

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

[ashmitp869]

@TomMartens Thanks for your help.

Will you able to help me in this query pls.

https://community.fabric.microsoft.com/t5/Desktop/Need-help-in-building-Paginated-report-data-coming...