Forum Discussion
Calculated Column IF Amount Exceeds Dynamic Threshold
Hi Anonymous
You want to create a column but the column is calculated to change dynamically, right?
This seems to be impossible in Power Bi due to the difference between the measure and the calculated column. Columns are calculated and saved in the capture as soon as you create it, so the result in column won’t change when you do something on slicer.
But you can try to use measure to show the result which defined to display based on the slicer
Variance_check = VAR Difference = CALCULATE( SUM( 'TB DATA'[Sales] ), 'TB DATA'[Period] = "CurrentYear" ) - CALCULATE( SUM( 'TB DATA'[Sales] ), 'TB DATA'[Period] = "PriorYear" ) RETURN IF( ABS( Difference ) > Threshold[Value], "Review", BLANK() )Then unselect show items no data
the result will behind the rows with blank。
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Measures can see the selection you make in the slicer or Parameter but Calculated Columns and Tables cannot see them because, adding columns and tables happens in the data model, once you add they are available to be used in the report.
To achieve your requirement, you can assign the measure to the Filter Pane and Visual Filter and apply it accordingly to filter out the items dont need.
Fowmy, thanks for the response. This will work, however, I wasn't intending to expose the Filter pane to users, but I guess there really isn't a way out for now. Appreciate your response.
Anonymous
The other way is to create new measures with required filters included but the option I suggested is easier. You can hide the filter pane from users or even hide even a single measure or a column from the users. Please refer to this article:
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-filter