Incorrect Quick Measure Variance Total

[roytap]

Hi,

I have created a Matrix table using Customer as Rows, Year as column with Sales value as shown below:

I create a Quick measure variance under Year Column as shown. However, when i check the Variance Subtotal, it is not summed up correctly. If you look at the 3rd row record, the SubTotal of Sales Amt is 788.40 + 7270 = 8058.4 which is correct. However, the subtotal variance is -6481.60 + 0 = -7270. 

Does anyone encounter the same issue that i faced? 

Thanks.

[roytap]

Just a quick point to note. Actually what i needed is the second Variance column (Column 4). However, i am unable to get rid of the first variance column (Column 2) which is why i am trying to look for alternative at the subtotal in this case. 

Is there any way that i could get rid or hide the first Variance column?

Thanks

[roytap]

Manage to find the solution by using the suggestion provided.

https://community.powerbi.com/t5/Desktop/How-to-calculate-percentage-change-from-prior-date-prior-re....

This is the workaround and it works, so its all good for me. However, i think the Quick Measure for variance total is still incorrect for some reason. Not sure whether that is a bug for this visualization.

[PaulDBrown]

I'm not sure what your measure is supposed to compute, but from looking at the numbers in the columns, the "Variance Column" in bold on the far right appears to be the result of subtracting the "total Sales Amount" from the "2018 sales amount column".

For the row AMANJAYA SPECIALIST CENTRE s/b Kedah:

2018 sales amount            total sales amount      Variance

      4.539                                 32.232                       -27.693

(ie: 4.539 - 32.232 = -27.693)

So what exactly was the variance column supposed to compute?

[roytap]

Hi Paul,

Currently, this is what the table show based on AMANJAYA SPECIALIST CENTRE s/b Kedah:

       (a)                (b)                 (c)               (d)             (e)              (f)

Sales 2018     Variance     Sales 2017    Variance   Total Sales    Variance

    4539               0                27693        -23154        32232        -27693

From my understanding (d)=(c) - (a) where we will get the variance,

(e)=(a) + (b) which is the total sales of 2018 and 2017,

so for the total variance (f), it should be (b) + (d), but not (a)-(e) as what you stated. 

Is my understanding incorrect when it comes to the automatic formulation of Total and subtotal for a matrix table?

[PaulDBrown]

@roytap

It would seem so.

I'm curious as to what the "rogue" measure is? can you post it (with the column ids) so we can see what it is actually calculating?