cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EvertonRamone Regular Visitor
Regular Visitor

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: DAX

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
1 REPLY 1
Community Support Team
Community Support Team

Re: DAX

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |