How to Calculate % from the data given in a column

[Anonymous]

I have a column with the status of the actions and want to calculate %action closed, %Action Open, %Action Rejected etc. Somehow, I am unable to calculate it, can anyone help me?

Status

Closed

Closed

Submitted

Open

Rejected

Open

[v-yalanwu-msft]

Hi, @Anonymous ;

You could create a measure as follows:

%percent = DIVIDE(CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),[Status]=MAX([Status]))),CALCULATE(COUNT([Status]),ALL('Table')))

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jihwan_Kim]

Percent Status : =
DIVIDE (
COUNTROWS ( Data ),
CALCULATE ( COUNTROWS ( Data ), REMOVEFILTERS ( 'Status'[Status] ) )
)

Link to the pbix file 

[Portrek · Accepted solution]

Hi SamratQuality

you can use the measure below

Measure = 

var countstatus = COUNT('Table'[Status])
var sumcount = CALCULATE(COUNT('Table'[Status]),ALL('Table'))
return

DIVIDE(countstatus,sumcount)

After, you select this measure and press the % buttom

If that measure helps you, accept that solution for you post.

Best Regards.