Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
47 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |