Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a table with such columns:
Clients | Point | Date |
Client 1 | P1 | 01.01.2019 |
Client 1 | P1 | 01.01.2019 |
Client 1 | P2 | 01.01.2019 |
Client 2 | P1 | 01.01.2019 |
Client 2 | P1 | 01.01.2019 |
Client 3 | P3 | 01.01.2019 |
Client 4 | P1 | 01.01.2019 |
I need to count clients, who visited points P1 && P2, I tried different ways, but nothing.
Solved! Go to Solution.
@Anonymous Hope you are looking for something like this...
Test142 = VAR _P1 = SELECTCOLUMNS(FILTER(Test142Measure,Test142Measure[Point]="P1"),"Client",[Clients]) VAR _P2 = SELECTCOLUMNS(FILTER(Test142Measure,Test142Measure[Point]="P2"),"Client",[Clients]) VAR _Both = CALCULATE(DISTINCTCOUNT(Test142Measure[Clients]),INTERSECT(_P1,_P2)) RETURN _Both
Proud to be a PBI Community Champion
@Anonymous Hope you are looking for something like this...
Test142 = VAR _P1 = SELECTCOLUMNS(FILTER(Test142Measure,Test142Measure[Point]="P1"),"Client",[Clients]) VAR _P2 = SELECTCOLUMNS(FILTER(Test142Measure,Test142Measure[Point]="P2"),"Client",[Clients]) VAR _Both = CALCULATE(DISTINCTCOUNT(Test142Measure[Clients]),INTERSECT(_P1,_P2)) RETURN _Both
Proud to be a PBI Community Champion
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |