% of sales by Day

[Vincem35]

Good morning All, 

I am trying to get the % of sales by day.

So far i am able to map both total sales and day as per below chart (White line)

i inserted a new column in my data set named Week day in which i have all my Day.

I am having a challenge to represent the % of of total sales by day (7 days = 100%)

I tried this formula but yet i have 100% for each day which is not the expected value - it sees

Total Sales Incl. Tax % = 
var Total_Sales = CALCULATE([Total Sales Incl. Tax],  all('FBP  Transactions'[Week day]))
Var Calc = divide([Total Sales Incl. Tax], Total_Sales)
RETURN Calc<p> </p><p>Do you have any idea how i can get this value?</p><p>Thanks</p><p> </p>

[mahoneypat]

Your measure looks ok.  Do you have a sort by column on your Week Day column?  If so, you'll need to add that column also to your ALL. 

ALL(Table[Weed Day], Table[Week Day Sort])

Regards,

Pat

[Vincem35 · Accepted solution]

Awesome - it works!