Forum Discussion

nkulesa's avatar
nkulesa
New Member
2 years ago

Creating a Table Visual with Column-Level filters

Hello, wondering if anyone had any insight on this, I don't necessarily know how to title what I would like to see. 
I have several different metrics that each return:

1 if they're in the 90th percentile or higher

2 if they're in the 10th percentile or lower

3 if they're between 10th and 90th percentiles

4 if they do not meet the criteria for that specific metric


Example:

P.AutoGrossRenew = IF('Dashboard Data'[Auto In Force Policy Count 2023]<5,
                            4,
                        IF('Dashboard Data'[Auto Rolling 12 Gross Renewal Rate]>=
                                PERCENTILE.INC('Dashboard Data'[Auto Rolling 12 Gross Renewal Rate],0.9),1,
                        IF('Dashboard Data'[Auto Rolling 12 Gross Renewal Rate]<=
                                PERCENTILE.INC('Dashboard Data'[Auto Rolling 12 Gross Renewal Rate],0.1),2,
                         3
             )
))

I was hoping to get these all inside of a single table visual and only display the ones in the top 10/bottom 10 and then hide all others. The problem that I'm running into is that if I set for example a visual-level filter that says [Metric]=1, it then excludes all other metrics. I was wondering if there was a way to write measures so that they might all live together in the same visual.

Thanks!

 

2 Replies