Set analysis to filter on Qualify Table field

[ivandrago]

Hi,

I have the attached Document where I have two charts "Analysis" and "Customer Analysis", when I select a Customer from the "Customer Analysis" chart the other table will go empty. The reason for this is that the chart "Analysis" is using measures from a Qualify table, therefore I want the set analysis within the measures to use the Customer from the Qualify table, is this feasible?

Thanks

[swuehl · Accepted solution]

Maybe like

Sum({$<[Record Type] = {'Engineer'},Customer=, EUV.Customer =p(Customer)>} [EUV.Fixed])

[ivandrago]

Nice work Stefan! Thanks