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

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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]))