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.
The total row is only getting the average of part of the row.
My measure is:
You help is much appreciated!
Solved! Go to Solution.
I discovered that column/row subtotals do not work on the FALSE section of IF statements. For example, the subtotal of "=IF("any day before today", 10, 5)" will always be 10, even if a date includes a day after today. Current solution I am exploring is using a calculated column to do the measure's IF statement.
Hi @ShNBl84 ,
I have a little confused about your requirement.
What do you want to achieve in power bi? Is the image your desired output?
In addition, how do you predict that the sales for Wednesday is 11.5%?
If it is convenient, could you share your data sample with table format and the desired output so that we could have a test on it?
Best Regards,
Cherry
Thanks for your reply.
The image is my current output that has the total only including the days of actual sales. I want it to include all the days (even the predicted sales).
For the sales percentages, those are hard coded values.
Below is some sample data:
NumberDayWeekly Sales %
1 | Monday | 0.103 |
2 | Tuesday | 0.1136 |
3 | Wednesday | 0.1134 |
4 | Thursday | 0.1259 |
5 | Friday | 0.1946 |
6 | Saturday | 0.2113 |
7 | Sunday | 0.1382 |
ItemSalesDayStoreDay Number
Abc | 8 | Monday | 1 | 1 |
Abc | 7 | Tuesday | 1 | 2 |
Abc | Wednesday | 1 | 3 | |
Abc | Thursday | 1 | 4 | |
Abc | Friday | 1 | 5 | |
Abc | Saturday | 1 | 6 | |
Abc | Sunday | 1 | 7 | |
Abc | 7 | Monday | 2 | 1 |
Abc | 7 | Tuesday | 2 | 2 |
Abc | Wednesday | 2 | 3 | |
Abc | Thursday | 2 | 4 | |
Abc | Friday | 2 | 5 | |
Abc | Saturday | 2 | 6 | |
Abc | Sunday | 2 | 7 | |
Abc | 6.74666666666667 | Monday | 3 | 1 |
Abc | 6.94 | Tuesday | 3 | 2 |
Abc | Wednesday | 3 | 3 | |
Abc | Thursday | 3 | 4 | |
Abc | Friday | 3 | 5 | |
Abc | Saturday | 3 | 6 | |
Abc | Sunday | 3 | 7 |
I discovered that column/row subtotals do not work on the FALSE section of IF statements. For example, the subtotal of "=IF("any day before today", 10, 5)" will always be 10, even if a date includes a day after today. Current solution I am exploring is using a calculated column to do the measure's IF statement.
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 |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |