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
talderton's avatar
talderton
Frequent Visitor
3 years ago

Thanks.

It didnt like this formula.

So I changed it slightly to get the correct variable names.

Now it still doenst like one aspect of it (shown in red below):

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]),('MACSIS 2019 and 2021 survey restructured'[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]),('MACSIS 2019 and 2021 survey restructured'[Positive reponse]] in {"Positive","Negative"}))))))
 
Can you advise?
 
Thanks
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi talderton 

    Whether you mean to show the ratio of negative types and positive types, if you need to calculate this, you can consider the following two methods

    1.Put the [Positive response] into a slicer, then create the measure

     

     

    Positive response percentage of students = DIVIDE (CALCULATE (sum('MACSIS 2019 and 2021 survey restructured'[Number of students]),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]),'MACSIS 2019 and 2021 survey restructured'[Positive reponse]] in {"Positive","Negative"}))

     

     

    2.You need to create two measures, one is positive, the other is negative. the measure can refer to the original measure I offered before. The originsl measure calculates positive type, then you need to create a new measure to calculate negative type.

     

    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.

     

    • talderton's avatar
      talderton
      Frequent Visitor
      3 years ago

      Thanks for that.

       

      I am getting a message that: 'The end of the input was reached' for this calculation, but nothing is showing in red so its not telling me why its failed.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi talderton 

        Can you provide some error message picture?

         

        Best Regards!

        Yolo Zhu