Forum Discussion

spandy34's avatar
spandy34
Icon for Responsive Resident rankResponsive Resident
4 years ago
Solved

DAX Contains Text Statement

I am trying to calculate the total cost of Amount Recovered using [Net] field of the records within the  Main Claim Data field that has OT in the ClassofBusinessCode and the PolicyCode contains REC ...
  • PijushRoy's avatar
    PijushRoy
    4 years ago

    spandy34 

    Please create a calculated colum (dont give space between table name and col name)
    calculatedcolumn = SEARCH("REC",'Table'[PolicyCode],,-1)
    Then create measure
    = CALCULATE(SUM('Table'[Net]),'Main Claim Data', [ClassOfBusinessCode] = "OT" && 'Main Claim Data',[calculatedcolumn] > 0)

    If solve your requirement, please mark this answer as SOLUTION
    If this comment helps you, please LIKE this comment/Kudos

PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
4 years ago

spandy34 
Please try this,
= VAR _rec = SEARCH("REC",'Table'[PolicyCode],,-1)
RETURN
CALCULATE(SUM('Table'[Net]),'Main Claim Data', [ClassOfBusinessCode] = "OT" && _rec > 0)

If not solved, please keep posted (paste sample data)
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos

spandy34's avatar
spandy34
Icon for Responsive Resident rankResponsive Resident
4 years ago

This is the message I get

 

  • PijushRoy's avatar
    PijushRoy
    Icon for Community Champion rankCommunity Champion
    4 years ago

    spandy34 

    Please paste some sample data here or share pbix 

    • PijushRoy's avatar
      PijushRoy
      Icon for Community Champion rankCommunity Champion
      4 years ago

      spandy34 

      Please create a calculated colum (dont give space between table name and col name)
      calculatedcolumn = SEARCH("REC",'Table'[PolicyCode],,-1)
      Then create measure
      = CALCULATE(SUM('Table'[Net]),'Main Claim Data', [ClassOfBusinessCode] = "OT" && 'Main Claim Data',[calculatedcolumn] > 0)

      If solve your requirement, please mark this answer as SOLUTION
      If this comment helps you, please LIKE this comment/Kudos