Forum Discussion
Table based on What if parameter selected value
Hello Friends.
I currently am trying to learn something on PBI and i have been trying and failing for many days.
So my goal is to create a table in Power BI that is essentially like this -
Test =
summarize(
filter('Table', 'Table'[IF_FINAL]="YES"),
'Table'[Customer], "SALES",CALCULATE(sum('Table'[Value])))
The column being referenced named [IF_FINAL] is read like this.
The column being referenced named [IF_FINAL] is read like this.
IF_FINAL = if('Table'[Period]>'Table'[SLICER_FINAL],"YES","NO")
Slicer final is as follows -
Slicer final is as follows -
SLICER_FINAL = SUMMARIZE('SLICER',"VARIABLE",calculate(value(selectedvalue(SLICER[SLICER]))))
This returns nulls.
I want to be able to move the what if parameter and the new table change based on that new selected value.
Is there anyway in Power bi to make a table using DAX respect a value of a parameter? I have tried allselected() as well as selectedvalue()
I dont see anywhere to attach the PBI file I am working on, does anyone know how i can link it so you guys can see what I mean?
This returns nulls.
I want to be able to move the what if parameter and the new table change based on that new selected value.
Is there anyway in Power bi to make a table using DAX respect a value of a parameter? I have tried allselected() as well as selectedvalue()
I dont see anywhere to attach the PBI file I am working on, does anyone know how i can link it so you guys can see what I mean?
1 Reply
Calculated tables and columns are only calculated during data refresh, so there is no way for them to respond to filters or slicers.
Depending on what you want to do with the table, you might be able to achieve your goal using a table variable calculated within a measure.
