Forum Discussion

ROG's avatar
ROG
Icon for Responsive Resident rankResponsive Resident
4 years ago
Solved

Dax measures help need

Hi all,

 

I posted a question here this morning but I didn't get the full solution, so I thought I would post here where I got stuck at. 

I want to add a new column saying 'Customer type change?' = "1" if the product is different bettween the columns (First_CustType and CurrentCustType) and "0" if they have the same product.

 

 

A super user friend adviced me using the below.

Column = IF([First_Product] = [CurrentProduct],0,1)

 

For the highlighted below, do they need to be a measure?  The columns from my table are just fields from different tables (Cust_ID and First_CustType come from the table ProductAcquisition, and CurrentCustType comes from the table CustomerType. I tried to create both measures so I can create the measure below but it's not working. Se below the error I get. 



 

 

How can I get this done? 

Thank you.

Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi ROG ,

    Please try below options:

    My test table:

    ProductAcquisition:

    CustomerType:

    Model:

     

    Try below DAX to add new column in table ProductAcquisition:

    CurrentCustType_FromCT = RELATED(CustomerType[CurrentCustType])
    Column = if([First_CustType]= [CurrentCustType_FromCT],1,0)

     

    Best regards,

    Community Support Team_ Binbin Yu

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

2 Replies

  • Barthel's avatar
    Barthel
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hey,

     

    In measures you cannot directly refer to columns, because there is no row context. Your matrix contains the columns, so based on the filter context per row there is only one value for the columns. We can retrieve this single value using the SELECTEDVALUE function. Use this code for your measure:

     

     

     

    Measure =
INT (
    SELECTEDVALUE ( ProductAcquisition[First_Product] )
        = SELECTEDVALUE ( ProductAcquisition[Current_Product] )
)

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi ROG ,

    Please try below options:

    My test table:

    ProductAcquisition:

    CustomerType:

    Model:

     

    Try below DAX to add new column in table ProductAcquisition:

    CurrentCustType_FromCT = RELATED(CustomerType[CurrentCustType])
    Column = if([First_CustType]= [CurrentCustType_FromCT],1,0)

     

    Best regards,

    Community Support Team_ Binbin Yu

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