I have a measure that adds up a column and then divides each row in that column by the total of the column (calculating percentage). However, when I filter by a different column, the original total of the column changes. I am trying to make it so the total of the column will not change even when filters are applied.
I want it to look like the yellow where if you filter something out, it will still take that number into account when computing the total. Hoping to modify my measure/create a new one that can do this.