Summing Measures on multiple sheets

[tomshaw83]

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

[lbendlin]

If you want the measures be impacted by filter choices on "other" sheets then you need to use synced slicers or report level filters.