The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
12 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
24 | |
14 | |
13 | |
9 | |
7 |