Forum Discussion
Anonymous
7 years agoNot applicable
Percentage Of Total Measure
Hi, I want to add a a column to my table that is essentailly: Column A Row Value / Sum(Column A) But I need it to interact with a slicer so using a calculated column doesn't work because ...
- 7 years ago
Measure = Selectedvalue([Column which i only want the single value]) / Calculate(sum([column A]),allselected([column A]))
Try this, we might be using different delimiters!
tex628
7 years agoCommunity Champion
Measure = Selectedvalue([Column which i only want the single value]) / Calculate(sum([column A]),allselected([column A]))
Try this, we might be using different delimiters!
Anonymous
7 years agoNot applicable
Spot on, works perfect, Thanks!