Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Member case ID
jim a1
jim a1
jim a1
jim a2
jim a3
bob b1
bob b1
bob b2
sam c1
sam c2
sam c3
Hello Experts
I'd like a measure that will show
Total number of members with 3 and up UNIQUE case IDs, in this case = 2 (jim and sam)
thank you
Solved! Go to Solution.
hi @konijay
try like:
Measure =
VAR _table =
ADDCOLUMNS(
VALUES(TableName[Member]),
"Count",
CALCULATE(DISTINCTCOUNT(TableName[Case ID]))
)
RETURN
COUNTROWS(
FILTER(_table, [Count]>=3)
)
hi @konijay
try like:
Measure =
VAR _table =
ADDCOLUMNS(
VALUES(TableName[Member]),
"Count",
CALCULATE(DISTINCTCOUNT(TableName[Case ID]))
)
RETURN
COUNTROWS(
FILTER(_table, [Count]>=3)
)
LOVE U!
User | Count |
---|---|
54 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
80 | |
57 | |
40 | |
19 | |
10 |