topic Re: Data Handling with Multiple Measures in App Development

Data Handling with Multiple Measures

jdean1012 — Sat, 16 Nov 2024 19:15:26 GMT

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!

Re: Data Handling with Multiple Measures

Kashyap_R — Wed, 22 Jan 2020 14:38:32 GMT

Please go through the attached QVF sheet3

Hope this helps

Thanks

Re: Data Handling with Multiple Measures

jdean1012 — Wed, 22 Jan 2020 18:21:36 GMT

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

Re: Data Handling with Multiple Measures

jdean1012 — Wed, 22 Jan 2020 18:59:38 GMT

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.

Re: Data Handling with Multiple Measures

Kashyap_R — Wed, 22 Jan 2020 20:50:30 GMT

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

Re: Data Handling with Multiple Measures

jdean1012 — Wed, 22 Jan 2020 21:57:32 GMT

Awesome! THANKS SO MUCH!!!