Forum Discussion

BhagyashriM42's avatar
BhagyashriM42
Frequent Visitor
4 years ago
Solved

Calculated column- percentage using different columns

Hello Community,   I want to calculate a calculated column where it will give the % of particular categories as given in the screenshot,I have tried using earlier function to get count of "Happy" a...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

You should be writing a measure for this - not a calculated column formula.  If you are interested, share the link from where i can download your PBI file.

  • BhagyashriM42's avatar
    BhagyashriM42
    Frequent Visitor
    4 years ago

    Hi Ashish,

     

    Right, I had done this on measure ,but there is a situation where I need a calculated column itself to take a lookup in other table and all other calculations are indirectly dependent.

     

    Thanks,

    Bhagyashri

    • SpartaBI's avatar
      SpartaBI
      Community Champion
      4 years ago

      BhagyashriM42 you can PM to do a zoom call