Forum Discussion
Multiply values from one table and another
Dear all, I need to multiply the values from the three columns "AMOUNT_GROUP", "Faktor für x-Leiter" and "Multiplier". I assume this is quite easy to solve, but obviously I am too stupid... ...
Hi Orstenpowers ,
My recommendation is to create explicit measures rather than relying on implicit ones, as this will allow you to multiply those measures more effectively. The three columns from the two different fact tables seem to be filtered by a common dimension table, which is applied in the row context of your table visual. By using explicit measures, the multiplication will be correctly filtered by the same row context.
Best regards,