Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am new to Power BI and trying to create a measure that will count the number of times that a customer is listed in a table. The count also needs to update when different filters are selected.
So in the example below:
Customer A
Customer B
Customer B
Customer C
Customer C
Customer C
Customer C
The measure would show 1 for Customer A, 2 for Customer B, and 4 for Customer C.
Any help on how to accomplish this is very much appreciated.
Thanks - Erin
Solved! Go to Solution.
Hi @erin_g
I prefer this one
Measure = CALCULATE(COUNTROWS(Table), ALLEXCEPT(Table, Table[Customer]))
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |