Forum Discussion
IF Formula Calculated Column
Hi Julius410 ,
You could create a dynamic measure to display the budget value.
Before you create the measure, create a table with the following values for the slicer.
You can create it by entering data.
Then create the measure.
Budget value = SWITCH ( SELECTEDVALUE ( 'For Slicer'[Budgeted] ), "Budgeted", CALCULATE ( SUM ( 'Table'[Budget] ), FILTER ( 'Table', [Budget] > 0 ) ), "Budget N/A", BLANK () )Here's the results. When you select 'Budgeted' in the slicer,
When you select 'Budget N/A' in the slicer,
Hope to help you.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi amitchandak,
Thanks for your reply but this doesn't fix my issue. I'll try to explain it better.
I need a slicer that allows me to differentiate between projects which have a budget (>0) and projects which do not have a budget (<=0 or =BLANK()). When I select the filter for budgeted projects it should still display the data that sits in in the Actual and Forecast column. Currently, this is not the case.
Any idea how I can achieve that?
Thank you.
Julius
Hi Julius410 ,
You could create a dynamic measure to display the budget value.
Before you create the measure, create a table with the following values for the slicer.
You can create it by entering data.
Then create the measure.
Budget value =
SWITCH (
SELECTEDVALUE ( 'For Slicer'[Budgeted] ),
"Budgeted", CALCULATE ( SUM ( 'Table'[Budget] ), FILTER ( 'Table', [Budget] > 0 ) ),
"Budget N/A", BLANK ()
)
Here's the results. When you select 'Budgeted' in the slicer,
When you select 'Budget N/A' in the slicer,
Hope to help you.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.