Summing Measures on multiple sheets
Hi there, I have a PowerBi file with tables on four different worksheets. On each table is a measure that counts the distinct number of people that appear in the table. What I am looking for is a measure that sums those four measures, that I can put on each sheet. The difficulty I am having is that I want it to dynamically update when I filter any of the sheets. For example if I filter the values on sheet 2 and reduce the distinct count measure for that sheet, then at present the the cumulative measure reduces on sheet 2, but does not reduce on sheets 1, 3 & 4. I hope that makes some sense Thanks Tom