Column for Percentage

[PPalkowski]

I have this simple table, how can I add a percentage column?

Meaning percentage of total hours for each Type

[v-frfei-msft · Accepted solution]

Hi @PPalkowski ,

We can create a calculated  table as below.

Table = 
SUMMARIZE (
    AllChanges,
    AllChanges[Type],
    "hours", DISTINCTCOUNT ( AllChanges[Number] ),
    "Percentage", FORMAT (
        DIVIDE (
            DISTINCTCOUNT ( AllChanges[Number] ),
            CALCULATE ( DISTINCTCOUNT ( AllChanges[Number] ), ALL ( AllChanges ) )
        ),
        "Percent"
    )
)

Pbix as attached.

[PPalkowski]

Yikes, This works wonderful, but this is a total for Jan and Feb... I was going to add a slicer to drive monthly metrics, is there a way to create a relationship from this new table on AllChanges[Number]?

Thanks!!

[edhans]

Something similar to this:

Percentage =
VAR Numerator =
    SUM( Table[Hours] )
VAR Denomenator =
    CALCULATE(
        SUM( Table[Hours] ),
        REMOVEFILTERS( Table )
    )
VAR Result =
    DIVIDE(
        Numerator,
        Denomenator,
        0
    )
RETURN
    Result