Is there a better way to filter measures by attributes other than the 'FILTER' SQL function

Question

I ahve found the FILTER function in DV to be very buggy, is there any other function I can use.

Example:

(Filter("VRM - Auction Sales"."Measures"."Sold Value (Net) % of CAP Black" using "VRM - Auction Sales"."Agreement - Current"."Termination Reason" = 'Mechanical Failure')

When the above measures isnt in the table the CAP column is this:

When i add the measure in it also affected the CAP column:

Gianni Ceresa · Answer

Did you look at the LSQL and the physical query behind both visualization? For your numbers to change like that, it could be an interference between the filtering and maybe some inner join doing some unexpected filtering or something linked to your data source. But it isn't possible to say more based on 2 screenshots.

The only element that matter is the query, the rest depends on that, so you should always start by looking at the queries. And then think at what data source you are using and how that could explain the difference in the queries etc.