Missing targets in Gauge

[Marcusbja]

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

[v-juanli-msft · Accepted solution]

Hi @Marcusbja 

Instead of a new table, with correct relationship, it works as well.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mwegener]

Hi,
you SUMMARIZE the data on the base of the Sales table.
If there is no sales row, it cannot be summarized.

https://dax.guide/summarize/

Please give Kudos for support.

If I answered your question, please mark my post as solution, this will also help others.

[Marcusbja]

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?

[mwegener]

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.