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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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