Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have these columns and I want to create a measure to calculate the number of types
| ID | Type |
| 1 | A |
| 2 | A |
| 3 | B |
| 4 | C |
| 5 | D |
| 6 | A |
| 7 | |
| 8 |
Results :
A = 3
B = 1
C= 1
D = 1
Blank =2
Solved! Go to Solution.
Not sure if I understood it correctly, but you can do this, it is the simplest.
or you could create a summarized table
Let me know if that what you need
THANK YOU BUT THE COUNT DOES NOT TAKE INTO ACCOUNT EMPTY VALUES
Not sure if I understood it correctly, but you can do this, it is the simplest.
or you could create a summarized table
Let me know if that what you need
If the Type column is created from a measure. How to create a measure to count the value in Type column?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 61 | |
| 46 | |
| 40 | |
| 38 | |
| 22 |
| User | Count |
|---|---|
| 178 | |
| 127 | |
| 117 | |
| 77 | |
| 56 |