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.

Reply

null

Content aside

  • 2 days agoLast active
  • 9Views
  • 1 Following