To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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