Forum Discussion

LABrowne's avatar
LABrowne
Icon for Helper II rankHelper II
2 years ago
Solved

DAX: PLACEHOLDER ERROR

Hi there,   I have the below code:   No. of Orders = CALCULATE (     COUNTROWS(Orders),     NOT(CONTAINSSTRING(Orders[OrderId], "Cancel")),     NOT(CONTAINSSTRING(Orders[OrderId], "Under Re...
  • Dangar332's avatar
    Dangar332
    2 years ago

    hi, LABrowne 

     

    try below

    CALCULATE (
    COUNTROWS(Orders),
    NOT(CONTAINSSTRING(Orders[OrderId], "Cancel")),
    NOT(CONTAINSSTRING(Orders[OrderId], "Under Review")),
    FILTER(
       VALUES(Orders[OrderId]),
      [OrderFil (%)] >= 1
    )
  )
Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

hi, LABrowne 

 

try below

CALCULATE (
    COUNTROWS(Orders),
    NOT(CONTAINSSTRING(Orders[OrderId], "Cancel")),
    NOT(CONTAINSSTRING(Orders[OrderId], "Under Review")),
    FILTER(
       VALUES(Orders[OrderId]),
      [OrderFil (%)] >= 1
    )
  )
LABrowne's avatar
LABrowne
Icon for Helper II rankHelper II
2 years ago

Thank you very much!