Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 ...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    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's avatar
HotChilli
Community Champion
7 years ago

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