DAX

[EvertonRamone]

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?

[v-shex-msft · Accepted solution]

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