Forum Discussion
Ngauti
3 years agoFrequent Visitor
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
- LuizKollerResolver I
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" ) - NgautiFrequent Visitor
Thankyou soo much, this is very helpful