Sum up all vlaues in line and stacked column chart

[rreck]

Hi all,

I am working on a dashboard and have the following problem:

We are controlling our colleagues by their sales. One colleague did not have any sales for product C in January. So far so bad. But as there were no data entries for that product in January, Power BI does also not include the targets for that certain product in its calculations.

Example

Sales by colleague: 

	January	February	March	April
Product A	10	30	30	20
Product B	15	5	5	5
Product C	0	5	5	5

Targets for colleague:

	January	February	March	April
Product A	20	30	40	10
Product B	10	20	30	20
Product C	10	10	10	10

Now, Power BI sums up the target for January to 30 (= 20 (A, Jan) + 10 (B, Jan)) and not 40 because there were no sales in January for Product C.

I am using a line and stacked column chart and also am working with a third table that displays products A, B and C which I am using to filter the content.

Any help how to calculate the correct sum?

Thanks in advance 🙂

[Ashish_Mathur]

Hi,

There should also be a Year column in both tables or along with the month, there should also be the year.  Share the 2 revised tables.

[lbendlin]

Sounds like your data model is missing a "Colleagues"  dimension table.