Forum Discussion
Variance in matrix table
I have the matrix table below. Each of the rows are measures - I've done this by the 'Switch Values to Rows' toggle. I'd like to calculate the variance between Actuals and Forecast is this possible? ...
Hi, Anonymous ;
You could create a table.
then create a measure as follow：
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous , Create a new table with values Actual, forecast and variance , Join it with that column ,
then create a measure like
if(Max(Dim[Actual Vs Forecast]) = "variance", calculate(Sum(Table[Value]), Dim[Actual Vs Forecast]="Actual") - calculate(Sum(Table[Value]), Dim[Actual Vs Forecast]="Forecast") , Sum(Table[Value]) )
use Dim's column [Actual Vs Forecast] in the visual