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

 

 

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

     

     

     

2 Replies

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