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]))

     

YalanWu_test's avatar
YalanWu_test
Icon for Helper I rankHelper I
4 years ago

Hi, azakir ;

You could create a column :

Column = IF('Table'[Equipment OEM]="793","1",[Equipment Code])

Then create a measure.

*Equipmentdescorcount = IF(MAX('Table'[Equipment OEM])="793", COUNT('Table'[Equipment Code]), MAX('Table'[Equipment Code]))

Add a matrix and setting it.

 

And 

The final show:

Best Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Thanks YalanWu_test This is great.