Forum Discussion

talderton's avatar
talderton
Frequent Visitor
3 years ago

Horizontal bar charts

Hi everyone,   I have created the table shown below that shows the % of positive answers by students for each school. I have used the following calculation in my table:   Positive response perce...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi talderton 

You can refer to the following measure

Positive response percentage of students = DIVIDE (CALCULATE (sum('MACSIS 2019 and 2021 survey restructured'[Number of students]),ALLEXCEPT('MACSIS 2019 and 2021 survey restructured','MACSIS 2019 and 2021 survey restructured'[Enumber]),[Positive_response]="Positive"),CALCULATE (sum('MACSIS 2019 and 2021 survey restructured'[Number of students]),ALLEXCEPT('MACSIS 2019 and 2021 survey restructured','MACSIS 2019 and 2021 survey restructured'[Enumber]),[Positive_response] in {"Positive","Negative"}))

Then put the measure to the visual and set sort by Measure

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.