Forum Discussion
Solved
Double grouping in visuals (no Power Query)
Hi there, how would one solve this sort of problem? I want to have a filtered visual for the following: DATA Clowns Balls Color ClownA 1 Red ClownB 2 Blue ClownC 3 Green Clo...
Hi,
PBI file attached.
Hope this helps.
My solution will not be affected by an additoinal Date column in Table1.
Indeed, upon double checking the formulas, I agree that it shouldn't make a difference.
There still is one issue. In the new data, I have a total of 5 balls for one of the clowns.
It does not come out in the result (more than 4 balls = 0, instead of 1).
Should work absolutely fine. If it is working fine for the other categories, there is no reason for it to fail for 1. Check thorughly.
DIY.