Forum Discussion
Column total and HASONEVALUE
Hi, I have this measure that is calculating the row total (per counterparty) based on another measure [P/L]. However, the column total is wrong so how can I include the date dimension ...
Hi Anonymous , thanks for your input.
The measure [P/L] is calculated using values from two different tables.
As in this simplified example, volumes from one table and prices from another table.
Measure for the total
P/L and P/L Total shows both wrong totals.
Apparently just adding the whole table in SUMX works in my simplified example,
but when doing it in the real case I just receive a blank matrix with no values.