Hi all,
I would like to get some help on an issue that I have with a matrix visual and a therein displayed measure. Due to confidential information, I cannot display sample data. However, the problem is like this:
I created a measure that at first filters two quantities from two different tables for two points in time. Afterwards I calculate the delta between these two quantities and multiply the result with a factor, that is stored in antother table. Finally, I use this measure in a matrix visual, in which I display the calculated values of this measure for different sub-groups.
When I activate the calculation of sub-totals for these sub-groups, the sub-totals for the measure do not add up the values of the underlying sub-groups but applys the measure on to the sub-totals themselves.
I tried two things:
- Create new columns to get the row-wise calculation but that disagrees with the reference to multiple tables
- Assign the measure itself to a new column. This works fine for one measure but with multiple measures I run into circular dependency problems.
Do you have any suggestions on how to solve this issue or whether it is possible to display the correct sub-totals with a measure that references multiple tables?
Cheers
