Data Handling with Multiple Measures

[jdean1012]

I have a table with multiple measures.  I'd like to filter out rows where Measure #1 = 0 while ignoring Measure #2.  Un-checking "Include Zero Values" under Add-Ons/Data Handling evaluates both measures and only filters out the rows where both #1 and #2 are zero.

Thanks for any assistance in advance!

[Kashyap_R]

Hi

Please go through the attached QVF sheet3 

Hope this helps

Thanks

[jdean1012]

Thanks for the reply.
Unfortunately, my measures are master items, which I don't think are allowed in dimension formulas.

[jdean1012]

Here is a more detailed explanation of the problem.  The "Non-Compliant Tickets" master measure is the field I would like to use to filter the table.  It is defined as follows:

Sum({<
[ReportFY] = {'Yes'},
[Regional Indicator] = {'International'},
[Customer] = {'Non-Customer'},
[Compliance] = {'Non-Compliant'}
>} [True Ticket Count])

I would like to see ONLY the rows in the yellow box, or, those travelers with 2 or more non-compliant tickets.

[Kashyap_R · Accepted solution]

Hi 

Try this

Go to Data >> Dimension  >> Limitation >> Exact value

Select   >=   2

Make sure that the dimension limit is based on non-compliant tickets measure if it is pointing to some other measure make sure to bring this measure up. I have tried on measure items it is working.

Hope this helps

Thanks

[jdean1012]

Awesome!  THANKS SO MUCH!!!