Forum Discussion
Totals incorrect
I figured it out. Here is what I ended up doing. I deleted what i had done. Then duplicated Table 1 and named as Table 2. Creating the Sum measure in Table 2 fixed it. So now if someone selects an individual city in Table 1, Table 2 will be filtered to show the Table 1 city as well as the associated cities and the totals add correctly. I am sorry for the bother ... I should have had no problem with this ....Thanks again. John
I figured it out. Here is what I ended up doing. I deleted what i had done. Then duplicated Table 1 and named as Table 2. Creating the Sum measure in Table 2 fixed it. So now if someone selects an individual city in Table 1, Table 2 will be filtered to show the Table 1 city as well as the associated cities and the totals add correctly. I am sorry for the bother ... I should have had no problem with this ....Thanks again. John
If it does what you want, then we'll and good, but I suspect the approach is not optimal. Your 2 tables look the same to me, so I wonder why you have 2 tables and wonder if you would be better appending them together in power Query into a single table. When you get the table structure right, everything else becomes easier