Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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>
Solved! Go to Solution.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Awesome - it works!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |