Aggregation with Date together with Filter per Type

[Anonymous]

Hi Everyone,

I have the following measure for Target 360 Ratio% which works great at establishing the 360 type out of 2 possible types, 360 and Cash:

So there are 6.1 instances of 360 out of a total of 11.69 --> 53%

Now the issue is when I calculate the same but AGGREGATED --> I know how to aggregate the Target-->

The problem arises when I'm trying to do both aggregation and do the 360 filtering.  Notice below that I am filtered on the 360 and want to keep it this way.

The yellow is also supposed to equal 53% in each of the cells. Here is the measure:

Can someone tell me what I'm doing wrong?

Many thanks,

Eyal

[Anonymous · Accepted solution]

I think i figured it out...