Forum Discussion

EvertonRamone's avatar
EvertonRamone
Helper I
8 years ago
Solved

DAX

I need a DAX measure wich shows me a flag (1 or 0) if a customer (DimCustomer) bought the product "A" someday (for the first time) and later (doesn't matter when) have bought or product "B" or "C"

 

Measure1: Flag (1 or 0) in their customer names if bought

Measure2: When was the first time that they bought product B or C

 

Basicly I have a FactSales, DimCustomer, DimDate and Dimproduct

 

Can someone help me?

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi EvertonRamone,

     

    Maybe you can try to use below formulas:

     

    #1,

    Measure1 =
VAR currCustomer =
    SELECTEDVALUE ( DimCustomer[Customer] )
RETURN
    IF (
        COUNTROWS ( FILTER ( ALLSELECTED ( Table ), [Customer] = currCustomer ) )
            > 0,
        1,
        0
    )

    #2,

    measrue 2
    =
    VAR currCustomer =
        SELECTEDVALUE ( DimCustomer[Customer] )
    RETURN
        CALCULATE (
            MIN ( DimCustomer[Date] ),
            FILTER (
                ALLSELECTED ( Table ),
                [Customer] = currCustomer
                    && [Product] IN { "B", "C" }
            )
        )

    If above not help, please share some sample data to test.

     

    Regards,

    Xiaoxin Sheng

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi EvertonRamone,

     

    Maybe you can try to use below formulas:

     

    #1,

    Measure1 =
VAR currCustomer =
    SELECTEDVALUE ( DimCustomer[Customer] )
RETURN
    IF (
        COUNTROWS ( FILTER ( ALLSELECTED ( Table ), [Customer] = currCustomer ) )
            > 0,
        1,
        0
    )

    #2,

    measrue 2
    =
    VAR currCustomer =
        SELECTEDVALUE ( DimCustomer[Customer] )
    RETURN
        CALCULATE (
            MIN ( DimCustomer[Date] ),
            FILTER (
                ALLSELECTED ( Table ),
                [Customer] = currCustomer
                    && [Product] IN { "B", "C" }
            )
        )

    If above not help, please share some sample data to test.

     

    Regards,

    Xiaoxin Sheng