Forum Discussion

ashmitp869's avatar
ashmitp869
Icon for Responsive Resident rankResponsive Resident
2 years ago
Solved

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

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
Need Help
  • TomMartens's avatar
    TomMartens
    2 years ago

    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

3 Replies

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    2 years ago

    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