I would like to return a value into a column depending on the selected value into a visual slicer, something like this:
Go to Solution.
SELECTEDVALUE() : Returns the value when the context for columnName has been filtered down to one distinct value only. Otherwise returns alternateResult.
I created a measure with your formula .
Return (IF(SELECTEDVALUE('Table'[Types])="Value", DIVIDE(100*_value1,SELECTEDVALUE('Table'[total_count])), Divide ( 100 * _value2 , SELECTEDVALUE('Table'[total_count]))))
You can refer to my measure to change your formula .
The final result is as shown :
Best Regards,Community Support Team _ Ailsa TaoIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
@Log2Ins SELECTEDVALUE only returns a value if you have one selection. Otherwise it returns it's alternative result which by default is BLANK. Also, I think you only want one =
Return (IF(SELECTEDVALUE('<table>'[Types])="Value", DIVIDE(100*var1_value, <table>[total_value]), Divide ( 100 * var2_count , <table>[total_count] )))
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.