Forum Discussion

tommpl's avatar
tommpl
Regular Visitor
8 years ago

Created column isn't calculating as expected

I have two calculated columns from my dataset. I am trying to get a % figure based on these columns. As you can see from the picture below the columns calculate correctly and have been sorted by operatorname as I would hope but the % calculation hasn't worked. I would expect the abort % column to be 15/66 = 0.227 and so on but that's not what I'm seeing. Am I doing something wrong?

 

definition

14 Replies

    • tommpl's avatar
      tommpl
      Regular Visitor

      Division didn't work. However DIVIDE did in that it resolved but it is still shows the incorrect figures.

       

       

       

       

      • rajulshah's avatar
        rajulshah
        Icon for Resident Rockstar rankResident Rockstar

        Hello tommpl,

         

        Can you please share your sample data or sample pbix file?