cancel
Showing results for
Did you mean:
Highlighted
Anonymous
Not applicable

## Count combined rows

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super Contributor

## Re: Count combined rows

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,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
New Contributor

## Re: Count combined rows

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

Super Contributor

## Re: Count combined rows

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,

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

Announcements

#### Community News & Announcements

Get your latest community news and announcements.

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 308 members 3,187 guests
Recent signins: