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
You have not provided enough information for anyone to help you. You need to post details of the relationships between tables and clarity on which tables the columns in your visuals come from.
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