Forum Discussion

JonArnold's avatar
JonArnold
New Member
3 years ago
Solved

DAX Filtering help in a measure

Hi I am trying to work out how to use a filter in a measure using DAX & I am going round in circles. I have a table that contains : ISSUE TYPE NVA_UNITS and a few other columns I want to create a m...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi JonArnold 
    Perhaps something like this?

    NUMBER OF DEFECTIVE UNITS =
SUMX (
    FILTER ( WFT_DATA, WFT_DATA[Issue_type] = "Qualität" ),
    WFT_DATA[NVA_UNITS]
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi JonArnold 
Perhaps something like this?

NUMBER OF DEFECTIVE UNITS =
SUMX (
    FILTER ( WFT_DATA, WFT_DATA[Issue_type] = "Qualität" ),
    WFT_DATA[NVA_UNITS]
)