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
jaideepnema's avatar
jaideepnema
Solution Sage
5 years ago

Hey Anonymous ,
You can create a flag that identifies the abc or def attribute which will be used to identify the denominator and then create a calculate column as shown below

PCT Calculation = 

var abc=CALCULATE(SUM('Table'[value]),'Table'[attrib]="abc",ALL('Table'))

var def=CALCULATE(SUM('Table'[value]),'Table'[attrib]="def",ALL('Table'))

var calc=IF('Table'[ABC]=1,DIVIDE('Table'[value],abc,BLANK()),DIVIDE('Table'[value],def))

return calc

Please accept this as solution if this helps !! Appreciate a Kudos ðŸ˜€