Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
I think i figured it out...