Forum Discussion
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 ...
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,
v-cherch-msft
Microsoft Employee
Microsoft EmployeeHi 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,