Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Vincem35
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

Awesome - it works!

View solution in original post

2 REPLIES 2
mahoneypat
Employee
Employee

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? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Awesome - it works!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.