Forum Discussion

jibran's avatar
jibran
Helper II
9 years ago
Solved

Custom column filter with user values

Hi, I am struggling to write a simple dax where I want to create a calculated column on the basis of database column like I have a table  ID      Product                Calculated Column 1       ...
Dashboards
Reports
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    jibran

     

    Please try with following DAX expression.

     

    Calculated Column = 
IF (
    SEARCH ( "Iphone", Table1[Product],, 0 ) > 0,
    "iphone",
    IF ( SEARCH ( "Samsung", Table1[Product],, 0 ) > 0, "android" )
)

     

    Best Regards,

    Herbert

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

jibran

 

Please try with following DAX expression.

 

Calculated Column = 
IF (
    SEARCH ( "Iphone", Table1[Product],, 0 ) > 0,
    "iphone",
    IF ( SEARCH ( "Samsung", Table1[Product],, 0 ) > 0, "android" )
)

 

Best Regards,

Herbert