DAX Weekly Total Sales by Store giving wrong totals

[Anonymous]

Hi,

I have sales data by weekly for each store.

And when I am calculatinng the sales % contributionn of each item at store level by weekly..

The measure which i have written is giving right value for each item wise whe calcualte the contribution in % as 

But my total sales values at each store and weekly is giving wrong total  here and hence the % values also coming wrong at total.

DAX:

_TotalSales = 

CALCULATE(SUM(FFD_ADOPTION_RESULT[SALES_AMT]),
FILTER(ALLSELECTED(FFD_ADOPTION_RESULT),FFD_ADOPTION_RESULT[Store_Name] = MAX(FFD_ADOPTION_RESULT[Store_Name]) && FFD_ADOPTION_RESULT[Week] = MAX(FFD_ADOPTION_RESULT[Week])))

%Sales = DIVIDE(SUM(SAL_AMT),_TotalSales,0)

Can anyone please correct my dax here to get the right total values.

Thanks,

Mohan V.

[amitchandak]

@Anonymous , for such case prefer a date table with Year Week column and week rank 

Have these new columns in Date Table, Week Rank is Important in Date/Week Table

Week Rank = RANKX('Date','Date'[Week Start date],,ASC,Dense)
OR
Week Rank = RANKX('Date','Date'[Year Week],,ASC,Dense) //YYYYWW format

These measures can help
This Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))
Last Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])-1))

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8