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