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        Iphone 3              iphone

2        Iphone 4              iphone

3        Samsung s6         android

4        Samsung s5         android

 

I want to create dax query in calculated column whereever there is iphone3, iphone4 calculated column shows iphone and where there is samsung s6 and samsung s5 it shows android

 

Many Thanks 

 

Jibran Ishtiaq

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

1 Reply

  • 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