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 table like this. I created a measure
Count Of Line = districtcount(Item Line) as a result it is returning total value 3 but how can I get 5 instead because when I calculate the average of Count of Line it returns 3/5= 0.6 where as I want the value 5/5=1
Thank you
@BishwaR , Try a measure like
Count Of Line = count(Table[Item Line])
Count Of Line = countrows(Table)
or
Count Of Line = distinctcount(Table[Item Line])
Use COUNTROWS() instead of DISTINCTCOUNT()
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 16 | |
| 7 | |
| 4 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 25 | |
| 13 | |
| 12 | |
| 10 | |
| 6 |