Forum Discussion

MORDax's avatar
MORDax
Frequent Visitor
4 years ago
Solved

Calculate Percentage based on 3 columns

As you can see, I have three columns (Col 1, Col 2, Value). How do I calculate percentage of how much column 1 contributes to column 2 only if it has the same column number. Have given a visu...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago
    Measure = 
if(HASONEVALUE('Table'[Column1]),
divide(sum('Table'[Value]),CALCULATE(sum('Table'[Value]),REMOVEFILTERS('Table'[Column1])))
)

    see attached.

MORDax's avatar
MORDax
Frequent Visitor
4 years ago

I do not want a visualization, I want a measure or a column where the values show.

 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago
    Measure = 
if(HASONEVALUE('Table'[Column1]),
divide(sum('Table'[Value]),CALCULATE(sum('Table'[Value]),REMOVEFILTERS('Table'[Column1])))
)

    see attached.