Apply specific filters to specific rows

[Anonymous]

Hello there! I have a rather simple doubt, but I'm still learning.

I had a bunch of columns related to one person and I wanted to transform these columns into rows, so I pivotted the information and got something like this:

Person	KPI	Score
John Doe	% of TGG completed	63,3%
John Doe	% of new users	31,1%
John Doe	% of points used	77,0%

For each KPI we have a specific score we want to show, for example, the first KPI should only be showed in the table if it's below 50%, the second one too, so it's showing correctly since it's 31,1%. For each KPI we have a specific value. How to filter the rows so only the values below what we want will show?
Thank you for the attention!

[amitchandak]

@Anonymous , Not very clear , Try a measure like this in place of score. Blank in else is important to remove rows. You can change conditions as per need

Switch( True(),
max(table[KPI]) = "% of TGG completed" && [Score] >= 50 , [Score],
max(table[KPI]) = "% of new users" && [Score] >= 50 , [Score],
max(table[KPI]) = "% of points used" && [Score] >= 50 , [Score],
blank())

[Anonymous]

Thank you for the response!
I did what you told me but it did not return the results as expected, in fact it kept giving errors. It gave me an idea though. Since I couldn't just hide the KPIs I don't want to appear I decided to create a column beside them showing the ones Below the Threshold.

Threshold =

var Score =

SUMX(

Performance,

Performance[Score by KPI])

RETURN

SWITCH(TRUE(),

MAX(Performance[KPIs]) = "Revenue" && Score <= 60, "Below",

"X" && Score <= 80, "Below",
"Y" && Score <= 50, "Below",
and so on for all the KPIs.

Problem is that it only works with the first line "Revenue", and I have to close the measure. Like this:

Threshold =

var Score =

SUMX(

Performance,

Performance[Score by KPI])

RETURN

SWITCH(TRUE(),

MAX(Performance[KPIs]) = "Revenue" && Score <= 60, "Below")

If I put any other argument like the example above, it will not work.

I'm sorry, I'm really trying to make it work, if anyone can help...

Here's an image of how it goes (The goal is to show that to all KPIs not just one):