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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
How can I get my rows to divide by my Total?
Example:
The Distinct Count of Equipment (MP) column divided by the total 253.
23/253
21/253, etc
Solved! Go to Solution.
AAA =
DIVIDE (
COUNT(TABLENAME[Equipment (MP)]),
CALCULATE (
COUNT(TABLENAME[Equipment (MP)]),
ALLSELECTED ()
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi,
This isn't giving me the correct values.
first one should be 23/253 = .091
second should be21/253 = .830
AAA =
DIVIDE (
COUNT(TABLENAME[Equipment (MP)]),
CALCULATE (
COUNT(TABLENAME[Equipment (MP)]),
ALLSELECTED ()
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@amandabus21
Can try the following measure. You can also include the filed that in your table visual on the very left inside ALLSELECTED
AAA =
DIVIDE (
DISTINCTCOUNT(TABLENAME[Equipment (MP)]),
CALCULATE (
COUNT(TABLENAME[Equipment (MP)]),
ALLSELECTED ()
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 12 | |
| 9 | |
| 9 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 27 | |
| 22 | |
| 20 | |
| 18 | |
| 12 |