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).
Nevermind. Fixed. It was a copy and paste error, as I duplicated a table when creating the new data source.
It's all good. Thank you so much. It works with this new data as well.