Percentage Of Total Measure

[Anonymous]

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 it calculates against the unfiltered sum as opposed to the slider filtered sum. I think I need to use a measure but I can't figure out how to get from a calculated column with the above formula to a measure that creates a column.

It feels like this should be really simple but I just cant seem to fomat it right

[tex628]

Measure = 
Selectedvalue([Column which i only want the single value])
/
Calculate(sum([column A]);allselected([column A]))

Try this in a matrix with [Column which i only want the single value] first and then this measure

🙂

[Anonymous]

Thanks, that looks along the lines of what I want, only issue is that the error "The syntax for ';' is incorrect" displays so I can't submit the measure.

[tex628 · Accepted solution]

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]

Spot on, works perfect, Thanks!