Forum Discussion
DAX mesaure / Need help
Hello, everyone, I am creating a DAX measure to calculate a distinct count using (Distinctcount) the number for which the "START" intervention exists and for which at least one "END" intervention ex...
sjoerdvn
Solution Sage
Solution Sagetry something like
Example measure = COUNTROWS(INTERSECT(
CALCULATETABLE(VALUES('Table 1'[Column 1]), 'Table 1'[Column 2]='Start')
,CALCULATETABLE(VALUES('Table 1'[Column 1]), 'Table 1'[Column 2]='End')
))