Filter a measure by a joined dimension

[Santiago_Abruzz]

[Cyril_MTL_Analy]

Hello @Santiago_Abruzz and welcome!

Usually when I see errors with filtered measure using another view’s dimensions, it’s related to the explores.

Do you have another explore that uses the endorsement view but not the prospect view?

If that’s the case then you’ll need to either join on that prospect view as well or remove that measure from said explore by using the parameter

fields: [-endorsement.altasnetascall]

[Santiago_Abruzz]

Hi @Cyril_MTL_Analy! Thanks for your answer,

That did the thing! With help from Looker support, but none the less, it led us to the right path.

Thank you again 😎

[enrico_spada-16]

what was the solution?