Dax Formula Switch to filter values instead of on total Average

[Anonymous]

Hi,

I am new to using Switch, but this seems straight forward. How can I filter out the values? I want to compare the Value of each club vs the average. Now it just compares it vers the total average. Here is my measure. Thanks!

CF Labels, New Net Fee =

                Var Threshold = [Member Dues /Mbr /Month, CY Avg.]

                Var Selected = VALUES(Club[Club Number])

                Var Result =

                Switch(

                    True(),

                    [Member Dues /Mbr /Month CY] > [Member Dues /Mbr /Month, CY Avg.], "🏅")

                    Return

                    Result

I want the Gold Metal to show up under each club instead of the total if it above the average.

Thanks!

[wlknsnBI · Accepted solution]

Something like this?