I want to apply filters to a measure called Numerator (countd of client ID) and another measure Denominator (countd of client ID). Then I want to see the difference or ratio (numerator / numerator). I'm able to achieve this using sets and set filters for each of the dimension filters but set filters don't allow me to include relevant values. So the set filter shows all values and is confusing to users.
I need to try to sort out the ratio calculation using filters since I can include relevant values with normal filters. I can't include the filters from my numerator sheet and denominator sheet on the ratio sheet because they basically cancel out .
In general when you want to use the same data twice for different purposes in your workbook the approach is to duplicate the data and union it to itself - your data is not accessible in the workbook so look at this simple example on how it is done
it is not your problem but will illustrate the process
Jim
