Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Percentage

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.
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    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

     

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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]))

     

     

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    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