Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
27 | |
19 | |
14 | |
11 | |
7 |