Forum Discussion

vincentakatoh's avatar
vincentakatoh
Icon for Helper IV rankHelper IV
9 years ago
Solved

DAX: Exclude if Count is ZERO

Hi,  Need help on DAX to exclude if Count= zero. Using below DAX formula.   1) PRT0_CFnFail = sum(Data[CountFnF]) <Sum of Count> 2) PRT1_AllDefectsFn = CALCULATE([PRT0_CFnFail],ALL(Data[FailDefec...
Need Help
  • kschaefers's avatar
    kschaefers
    9 years ago

    You can modify your DAX formula for (2) to  be:

    PRT1_AllDefectsFn = IF(ISBLANK([PRT0_CFnFail]),BLANK(),CALCULATE([PRT0_CFnFail],ALL(Data[FailDefectCode])))
cs_skit's avatar
cs_skit
Icon for Resolver IV rankResolver IV
9 years ago

Make Count Measure

 

Put Count Measure in Filter <> 0