Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
User | Count |
---|---|
50 | |
44 | |
18 | |
14 | |
14 |
User | Count |
---|---|
107 | |
58 | |
29 | |
21 | |
16 |