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 B...
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

     

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