Forum Discussion

Helper V

3 years ago

Solved

Row divided by Total

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

3 years ago

AAA =
DIVIDE (
    COUNT(TABLENAME[Equipment (MP)]),
    CALCULATE (
        COUNT(TABLENAME[Equipment (MP)]),
        ALLSELECTED ()
    )
)

Super User

3 years ago

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 ()
    )
)