Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |