Forum Discussion
Solved
Sum only once when multiple selection contained in csv column value
I have a table of schools and attendance figures The school names are in in CSV format I would like to sum the attendance figures only once per selected school The school selection is dynamic and...
Hi,
You should split the Schools column into multiple rows (in the Query Editor). Drag this measure to your visual
Measure = sum(Data[Pupils])
Hope this helps.