Percentage

[Anonymous]

Greetings,

I have used below measure to get total count - 

Count_total_steps = SUM('Sample-PRT028'[Total_Steps])

Now I need to divide total_Steps by count_total_steps to get the % of each Business_Process_Definition.

I tried using below formula but not working - 

Column = DIVIDE('Sample-PRT028'[Total_Steps],'Sample-PRT028'[Count_total_steps], ALLSELECTED)

Thanks for your help.

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

Try to change you formula "column" as below:

Column =
DIVIDE (
    SUM('Sample-PRT028'[Total_Steps]),
    CALCULATE ( [Count_total_steps], ALL ( 'Sample-PRT028' ) )
)

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Anonymous , In case you need a new measure

Measure = DIVIDE([Count_total_steps ],calculate([Count_total_steps], ALLSELECTED('Sample-PRT028')))

New column

Column = DIVIDE('Sample-PRT028'[Total_Steps],Sum('Sample-PRT028'[Total_Steps]))