Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to Calculate % from the data given in a column

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 Clo...
Need Help
Show and Tell
Tips and Tricks
  • Portrek's avatar
    Portrek
    5 years ago

    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.

Portrek's avatar
Portrek
Icon for Resolver III rankResolver III
5 years ago

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.