Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have only one table and cannot add dimensions. I'd like to count one field (ID) by another (State), but all include all possible States, regardless of later filters.
Solved! Go to Solution.
@Anonymous,
Add a calculated table and build relationship on [State] column, then add measure below.
Table = DISTINCT ( Table1[State] )
Measure = COUNT ( Table1[ID] ) + 0
Hi
I think this is what you are looking for. Create a measure with this formulea:
Cnt = CALCULATE(COUNT(TABLE1[ID]), ALL(TABLE1[STATE]))
if not, please explain your requirement , some sample data will help.
Thanks
Raj
No, that's not what I need.
I can't attach files, but I'll show you a screenshot.
@Anonymous,
Add a calculated table and build relationship on [State] column, then add measure below.
Table = DISTINCT ( Table1[State] )
Measure = COUNT ( Table1[ID] ) + 0
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |