cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

% of sales by Day

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)

 

Vincem35_0-1603971919854.png


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>

 

1 ACCEPTED SOLUTION

Accepted Solutions

Awesome - it works!

View solution in original post

2 REPLIES 2
Super User III
Super User III

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

 





Did I answer your question? Please mark my post as a solution! Kudos are also appreciated!

Proud to be a Super User!




Awesome - it works!

View solution in original post

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors