Get the percentage of each category of a column

[maneschr2022]

Hi, I would like to find a way to visualize the percentage of each category from a column called Status, but  I would like to use another column called ID as a reference for the total count of them (making sure there is a distinct count in the total of ID values)  as the rows contain duplicates.

Both columns look like this:

Status               ID

Approved        M1

Approved        M1

Rejected          E2

Initiated          F3

Initiated          P6

Pending          L4

Pending          L4

Approved        X9

Approved        X9

Approved        T8

Thanks for your help!

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picturea and the attached pbix file.

Percentage measure: =
DIVIDE (
    DISTINCTCOUNT ( Data[ID] ),
    CALCULATE ( DISTINCTCOUNT ( Data[ID] ), REMOVEFILTERS () )
)

[maneschr2022]

Thanks a lot!  it works perfect!