Missing data when not using extra filter

[SamuelHaag]

Hi guys,

I don't get the behaviour of my barchart and the data behind it. I want to see all the sales per month for the current year.  In addition the sales are divided by the workdays ("AT je Monat") per month. 

This is the Set Analysis that I'm using for that with some other filters:

(sum( {1<
[Businessyear] = {$(=year(today(2)))}

>}

sales
))

/

[Workdays per month]

This is how the chart looks like without any other filters:

Only two months are shown which is not correct

This is how the bar chart looks with a filter for the business year (here 2019). I don't know why it works here with the filter...

Do you have any idea?

Thanks!

[martinpohl · Accepted solution]

Hi,

I think the problem is 

/ Workdays per month

which are many values in one month over the years

so change to

max({{1<[Businessyear] = {$(=year(today(2)))}>}  [Workdays per month])

that only one number of business days per month are calulated

Regards

[SamuelHaag]

It works! Thank you so much!