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"  ...
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

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