cancel
Showing results for
Did you mean:
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
Highlighted
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: | |
Highlighted
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: | |