0
Filtering Based off of Measures and Totaling
I have a report that needs to be built where two of the measures that I am looking at, cannot equal 0 when they are added together. I created a new column to total them so I only have to filter on one variable. I am able to do this and it works great, however, I also need to total some of my measures to look at specific counts and values when the rows with the two measures do not equal 0. I understand you may not total on filters, sorting, N-of-N, or elimination logic, however, there must be some sort of plausible workaround. I don't agree with the statement that there is no use in totaling over something that you filtered on. Thank you.