Forum Discussion

petrk's avatar
petrk
New Member
1 year ago
Solved

percentage calculation

Hi, please for help. I have table like this, and I need calculate values in column "per of X", it is calculated by formula "per of X = value / X" where X is sum of all values which has in name "x". ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi petrk ,

     

    I've made a test for your reference:

    1\ I assuem there is a table(Table)

    2\Add a measure

    Per of X = 
Var CurrentItemValue =Max('Table'[value])
Var CurrentItemName= LEFT(SELECTEDVALUE('Table'[name]),1)
Var SUMValue=CALCULATE(SUM('Table'[value]),FILTER(ALL('Table'),LEFT('Table'[name],1)=CurrentItemName))
RETURN
CurrentItemValue/SUMValue

    3\Result

     

    Best Regards,

    Bof

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi petrk ,

 

I've made a test for your reference:

1\ I assuem there is a table(Table)

2\Add a measure

Per of X = 
Var CurrentItemValue =Max('Table'[value])
Var CurrentItemName= LEFT(SELECTEDVALUE('Table'[name]),1)
Var SUMValue=CALCULATE(SUM('Table'[value]),FILTER(ALL('Table'),LEFT('Table'[name],1)=CurrentItemName))
RETURN
CurrentItemValue/SUMValue

3\Result

 

Best Regards,

Bof