Add a column on table visual by using the summarize value

[Ngauti]

Hi Team,

i have a table like below & when i drag it on table visual then it will look like the below table (other screen shot).

i need a 3rd column on table visual that is "met or not met"  

for example if category "A" achieves 4 then it should called it as Met else not met.

if category "b" achieves 15 then it should called it as Met else not met

if category "c" achieves 6 then it should called it as Met else not met

[Ngauti]

Thankyou soo much, this is very helpful

[LuizKoller · Accepted solution]

Hey!

Goal = 
VAR CATEGORYGOAL = 
SWITCH(
    TRUE(),
    SELECTEDVALUE('Table'[Category]) = "a", 4,
    SELECTEDVALUE('Table'[Category]) = "b", 15,
    SELECTEDVALUE('Table'[Category]) = "c", 6
)


RETURN
IF(
    SUM('Table'[Value]) >= CATEGORYGOAL,
    "Met",
    "Not Met"
)