Forum Discussion
Helper IShow the selected numeric parameter in the calculated column
Hi There
I'm doing a dashboard to show the usable inventory based on their expiry date and the min. shelf life required. The latter is controlled by users via scrolling the numeric parameter bar from 0 to 12, with 1 as insterval.
I created a calculated column in the inventory table, where I directly typed the dax as
MinSL = SELECTEDVALUE('Parameter'[Parameter]).
The result is that all the column is just blank.
It is not technically feasible. The work around is to use measures and some disconnected that have the expected values to base the filter on. Attached is a sample pbix using that approach. The use case is to dynamically bin rows based on the slicer selection.
6 Replies
- danextian
Super User
Hi yamacha
Calculated columns and tables are not aware of any slicer selection. They update when the formula is modified, upon data refresh and/or when the underlying tables have been modified. What the calculated column seees as the value of MinSL is blank its result is blank. There maybe work arounds depending on what you're trying to achieve.
Please read and follow what's stated in this sticky post: https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
yamachaHi Danex(?)
Thanks for the prompt reply. Then may I know if there is any feasibility to get a column that can change with the manual input? Or you were exactly telling it's not feasible technically.
- danextian
It is not technically feasible. The work around is to use measures and some disconnected that have the expected values to base the filter on. Attached is a sample pbix using that approach. The use case is to dynamically bin rows based on the slicer selection.