1 - % of Column Total

[Anonymous]

How would I calculate this simple calculation in a filtered table?

[edhans]

This pattern will do a % of total.

Percent of Total =
VAR varCurrentAmount =
    SUM( Table[Column] )
VAR varTotal =
    SUMX(
        ALL( Table ),
        Table[Column]
    )
VAR Result =
    DIVIDE(
        varCurrentAmount,
        varTotal,
        0
    )
RETURN
    Result

If you need more help, provide data in the format provided by the links below and maybe a screenshot or description of expected results.

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum

[Anonymous · Accepted solution]

Thanks. I figured out that all I really needed to do was use ALL(filtered_column[field])

[edhans]

---

@Anonymous wrote:

Thanks. I figured out that all I really needed to do was use ALL(filtered_column[field])

---

You are welcome @Anonymous