Brushing and set analysis

[belromvar]

Hi community,

I have the following scenario. I am trying to apply the brushing technique (highlight not filter) and came to following problem.

I have one diagram with Month as dimension(Chart1)  and another one just below with Weeks als dimension (Chart 2). Both share the same expressions.

The problem comes because one Week can belong to 2 months.

In  my calculation I want to display only the No. of Rounds related to the selected month (like in Chart 3) but still show all the weeks.

In the case above, Chart 2 should show 4 and 1.

Is this possible at all?

Thanks!

[tresesco]

Try below expression:

=count(distinct RoundCounter)*avg({1}1)

[belromvar]

The calculation is right but it filters the "inactive" weeks out.

[tresesco]

Uncheck 'Supress zero-values' in presentation tab.

[belromvar]

Still not right, it assigns 0´s to the other values and I would like to see them, just with a different color.

[tresesco · Accepted solution]

Well, then try this?

=If(Cal_Week=Cal_Week, count(distinct RoundCounter), Count({1}distinct RoundCounter))

Note: Now you need to check zero suppression setting.

[belromvar]

Thanks for your help. It works