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.
Hi,
I've a table with daily targets per date and another table with sales quantity.
The sum of all daily targets is 248 but since we are missing a day with sales the cumulated target in the gauge is also missing the target for the day with no sales.
As you see below, i'm missing bot the target and the sales (zero) in the table.
The table fomula is:
Results = SUMMARIZE(Sales;
Dates[DateCYFY2020];
"Budget"; SUM(Budget[Budget]);
"Sales"; SUM(Sales[quantity]);
"Target"; SUM(Budget[+30%])
)
Should be:
Day | Budget | Sales |
1 | 2 | 1 |
2 | 2 | 2 |
3 | 2 | 3 |
4 | 2 | 0 |
5 | 2 | 2 |
What it looks like (the day is missing instead of showing value 0 in Sales)
Day | Budget | Sales |
1 | 2 | 1 |
2 | 2 | 2 |
3 | 2 | 3 |
5 | 2 | 2 |
Solved! Go to Solution.
Hi @Marcusbja
Instead of a new table, with correct relationship, it works as well.
Hi @Marcusbja
Instead of a new table, with correct relationship, it works as well.
Hi,
you SUMMARIZE the data on the base of the Sales table.
If there is no sales row, it cannot be summarized.
Please give Kudos for support.
If I answered your question, please mark my post as solution, this will also help others.
Hi,
So if I change the input table to Budget (where I have a value for the day where I am misssing sales it'll work?
I assume it, but I have no further information about your model to validate it.
Otherwise, you can also implement the proposal of Maggie Li.
Please give Kudos for support.
If I answered your question, please mark my post as solution, this will also help others.
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |