Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

SOLVED-Multiple variable in a measure returns Blank

  Hi Guys,   I have multiple variable in a measure and giving me a blank result. let say i have 4 variable inside the measure and one of then has a null value or zero. The formula is to multiply...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

The filter available are only year and month. All data will displayed on the dashboard. 
PY_Measures is a folder that store all the measures I created. Here is the sample of measure I created for where the _P1 variable comes from(output)

Pass_Input = Calculate(PY_Measures(touched), filter(PY,(PY[Category]='WB') && (PY[type='ALL')))

Pass = Calculate(PY_Measures(touched), filter(PY,(PY[Category]='WB') && (PY[type_category='Pass')))
  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    That is not valid DAX. Did you want to write PY_Measures[touched] ? What is the definition of that measure?

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      This should be a bracket not a parenthesis. please see the below changes.

      Pass_Input = Calculate(PY_Measures[touched], filter(PY,(PY[Category]='WB') && (PY[type]='ALL')))

Pass = Calculate(PY_Measures[touched], filter(PY,(PY[Category]='WB') && (PY[type_category]='Pass')))

Touched = SUMX(FILTER(PY, PY[py_input]=1),[py_input])--- py_input is a column with a default value of 1