Forum Discussion

Kassii's avatar
Kassii
Frequent Visitor
8 years ago

Calculated column and measure different values?

Hi guys

 

Wondering if someone could help me out please.

 

Currently I have a bunch of measures which are calculating values and they're are working as expected. Because (From what I have seen) power bi doesn't allow measures to have conditional formating, I need to place these values into columns, However placing them on a calc column will obviously give sum of that calculation on every row there is.

 

Is it possible to just put that exact value from the measure into the column, even it gets placed on every line and I can just used the Min or Max (it would be the same value anyways)

 

Thanks

Need Help
Tutorial Requests

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    8 years ago

    Kassiishare sample data and expected result. Condiional formatting works with measures with number value

    • Kassii's avatar
      Kassii
      Frequent Visitor
      8 years ago

      How do I assign the conditional formating? I have tried right clicking the field -> Conditional Formating -> background colour scales and that doesn appear to want to work?

       

       

      The issue is however that the formula being used on the measure, when applied to the column, calculates it for every row. Expected result in the image above and the result I am getting

       

      • parry2k's avatar
        parry2k
        Super User
        8 years ago

        Could you share what is your measure like? What you are trying to do and what are the expected result? Sample data will be helpful.