Forum Discussion

azakir's avatar
azakir
Icon for Resolver I rankResolver I
4 years ago
Solved

IF condition to show all values

Hi Guys. Need some help on an IF formula that I am trying to work out. Here's sample data:   Equipment OEM               Equipment Code 320         EX234 793         EX235 950         EX236 79...
General Comment
Need Help
Show and Tell
  • ShahabHoghooghi's avatar
    ShahabHoghooghi
    4 years ago

    You can use this DAX code and get the result:

    Equipment Code Replacement =
    VAR _Numbers = CALCULATE(COUNT(Equipment[Equipment Code]),
                             Equipment[Equipment OEM]=793,
                             REMOVEFILTERS(Equipment[Equipment Code]))
    RETURN
    IF(SELECTEDVALUE(Equipment[Equipment OEM])=793,
                                    _Numbers,
                                    SELECTEDVALUE(Equipment[Equipment Code]))

     

ShahabHoghooghi's avatar
ShahabHoghooghi
Frequent Visitor
4 years ago

You can use this DAX code and get the result:

Equipment Code Replacement =
VAR _Numbers = CALCULATE(COUNT(Equipment[Equipment Code]),
                         Equipment[Equipment OEM]=793,
                         REMOVEFILTERS(Equipment[Equipment Code]))
RETURN
IF(SELECTEDVALUE(Equipment[Equipment OEM])=793,
                                _Numbers,
                                SELECTEDVALUE(Equipment[Equipment Code]))