Hello Community - I have this measure which works somewhat, but what I actually need to use instead of just the table (Bill To Customer Dim), is a specific column inside of the table (customer number). Same for the ship to customer.
I've tried a few things and am getting things like the placeholder error message. In basic english, my goal would be to filter by something like "bill to customer dim, customer number" whereby customer number is the expression.
How can this measure be modified to allow for that additional filter context? I have the customer number on the two customer tables, so I just need to figure out how to get the measure to filter by those specific columns.
PS1Date Range Distinct Count of RMAs =
FILTER ( 'Bill To Customer Dim', [PSE1Date Range Measure] > 0 ),
FILTER ( 'Ship To Customer Dim', [PSE1Date Range Measure] > 0 ),
[Distinct Count of RMAs]