I have the following data-model with a DIM-Table and different FACT-Tables.
I would like to have one stacked column chart with the value from DIMValueType on the X-axis and the different values from the FACT-Tables on the Y-axis. Unfortunately I can't stack this multiple values, it's only possible with one value.
My idea is to combine all the values from the different FACT-Tables to get one value.
Is there a way to do it with a measure or whatever?