Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Percentage Calculation

Hi Power BI Community User,   I need your input while calculating the percentage column which is unique requirement. The first two rows in the below screen shot is to be divided by 'value' of 'att...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi vivran22 ,

Yes there are additional row. However, there are only attributes (abc & def) as denominator. The rows with attrib in (xyz,abc) should be divided by abc .All other rows are to be divided by def
 
Regards,
Manish
  • vivran22's avatar
    vivran22
    Community Champion
    5 years ago

    Anonymous 

     

    You may try this as calculated column:

     

    Percent = 
VAR _ABC = LOOKUPVALUE('Table'[Value],'Table'[attrib] , "abc")
VAR _DEF = LOOKUPVALUE('Table'[Value],'Table'[attrib] , "def")
VAR _CurrentAT = 'Table'[attrib]
VAR _Divide = DIVIDE('Table'[Value],IF(_CurrentAT in  {"abc","xyz"},_ABC,_DEF))
RETURN
_Divide

     

     

    Cheers!
    Vivek

    If it helps, please mark it as a solution. Kudos would be a cherry on the top 🙂
    If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)

    Blog: vivran.in/my-blog
    Connect on LinkedIn
    Follow on Twitter

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Vivek,

      When I am replicating the same in my issue, the fourth line gives me the following error 'Cannot find the name '[attrib]'

       

      BR,

      Manish Kumar