Filtering

[AndreasMoller]

Hello,

I got some problems with filtering and i hope someone can help me.

I have 1 table with 2 fields/measures with differents sources.
"Total Orders" with source "Order".
"Number of Claims" with source "Claim".

I also have these 2 fields that i filter on.
"Date" with both sources.
"Claim Reason" with source "Claim".

When i filter on "Date" it filtering on both measuers, which is correct.
But when i filter on "Claim Reason", then "Number of Claims" filters correct but "Total Orders" gets to 0 because its the "Wrong" source.
How can I make "Total Orders" to not be filtered when i filter on something in field "Claim Reason"?

[ogster1974 · Accepted solution]

You can ignore certain filters in your set analaysis.

e.g. Count({<[Claim Reason]=>} OrderId)

[AndreasMoller]

Thank you, it helped!