The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hello,
I would like to return a value into a column depending on the selected value into a visual slicer, something like this:
Solved! Go to Solution.
Hi @Log2Ins
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 .
Measure =
VAR _value1=100
var _value2=200
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 Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Log2Ins
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 .
Measure =
VAR _value1=100
var _value2=200
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 Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@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] )))
User | Count |
---|---|
39 | |
36 | |
30 | |
29 | |
21 |
User | Count |
---|---|
64 | |
40 | |
32 | |
18 | |
16 |