Forum Discussion
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...
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" )
Thankyou soo much, this is very helpful