The Totals for my Measure in Table and in the Sticker are not equal. How do I fix it?

[santoshcpg]

Hi Experts, 

I have been working on a Power Bi Dashboard. I have calculated multple measures all of them work fine.

eg.

I have a measure that calculates %change in my current week data vs my 10wk avg. 

$10wk AVG = IF('sqldb op_order'[YYWW]>MAX('sqldb op_order'[YYWW])-10,'sqldb op_order'[Value],0)/10

Current vs 10WK AVG = (SUM('sqldb op_order'[$Current Week])-SUM('sqldb op_order'[$10wk AVG]))/SUM('sqldb op_order'[$10wk AVG])
This one works absolutely fine. Both the Table Total and Sticker value match. 

But this there are these two measures on similar lines comparing current week data to 52 week average.- 

$52wk AVG = IF('sqldb op_order'[YYWW]>MAX('sqldb op_order'[YYWW])-100,'sqldb op_order'[Value],0)/52

and 

Current vs 52wk AVG = (SUM('sqldb op_order'[$Current Week])-SUM('sqldb op_order'[$52wk AVG]))/SUM('sqldb op_order'[$52wk AVG])

The Totals in the Table and the Sticker are not the same. (See screenshot attached below)

I'm not sure what's going wrong. 

Why does this occur? Amd how to fix it? Any help is appreciated. 

Update: This has been solved. I had a filter on my table which led to the difference in totals. 

[lbendlin]

12 months is not the same as 52 weeks.

[santoshcpg]

Hi @ibendlin Thanks for replying. 12 Months is just used as a Name of the Measure. I can always change it.

But if you check the formulas itself, there is no month based calculation, all of it is week based. So I don't think that should would be a source of the problem.

My main issue being The Total in the table for '52 wk AVG' and 'vs 52 wk AVg' are $239,840 and -11.82% respectively.  But the Stickers for  '52 wk AVG' and 'vs 52 wk AVg' are $253,589 and -16.60% . 

Both the Table and Stickers are using the same measures. But the value being output is different.

I haven't been able to figure out why. 

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[santoshcpg · Accepted solution]

Hey Ibendin, 

I figured out the issue. There was a filter on my table, which eliminated certain rows and thus led to difference in totals. 

Nonetheless, thanks for the prompt response and being available.