Forum Discussion

PKidd's avatar
PKidd
Frequent Visitor
3 years ago
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...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Shaurya's avatar
Shaurya
Memorable Member
3 years ago

Hi PKidd,

 

Can you please share some sample? The table in your visual doesn't seem to make sense. If A alone is 10 and B is 13, then A,B should not be 11.