Forum Discussion

Ngauti's avatar
Ngauti
Frequent Visitor
3 years ago
Solved

Add a column on table visual by using the summarize value

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 e...
Need Help
  • LuizKoller's avatar
    LuizKoller
    3 years ago

    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"
)

     

     

     

LuizKoller's avatar
LuizKoller
Resolver I
3 years ago

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"
)