Count combined rows

[Anonymous]

Hello, 

I´m new on power bi,  so I would like to know if the following is possible: 

The following table shows products by ticket and I would like to know:  

1.  how many times the combination of Product A and B  will appears, in this table Product A and  Product B will appear 3 times (Ticket: 10,11 and 13) .

2. how many times the combination of Product B and D will appears, in this table Product B and Product D will appears 2 times (Ticket 18 and 21) .

Is it possible to do it on Power BI?

Tickest	Products
10	A
10	B
14	B
14	D
11	A
11	B
12	A
12	G
13	A
13	B
17	B
17	F
18	B
18	D
20	C
20	D
21	B
21	D

I hope i was clear 

Thanks.... 

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

You may create measures as below:

Measure_A&B =
VAR a =
    CALCULATETABLE (
        VALUES ( Table1[Products] ),
        ALLEXCEPT ( Table1, Table1[Tickest] )
    )
RETURN
    IF ( { "A" } IN a && { "B" } IN a, 1 )

A&B_Count = CALCULATE(DISTINCTCOUNT(Table1[Tickest]),FILTER(Table1,[Measure_A&B]=1))

Regards,

[HotChilli]

a) create a table

Table = 
VAR _tickswithA = SUMMARIZE( FILTER(Table1, Table1[Products] = "A") , Table1[Tickest])
VAR _ticketswithB = SUMMARIZE( FILTER(Table1, Table1[Products] = "B") , Table1[Tickest])
RETURN
INTERSECT(_tickswithA, _ticketswithB)

b) B,D is similar.  There are lots of ways to do this.

p.s. B, D appears 3 times