Dynamic Calculated Column as Visual dimension

Hi kahn_ohara 

You are correct. Calculated columns in Power BI cannot be dynamic according to user input in the report. Only measures and what-if parameters can be dynamic. However, measures and what-if parameters cannot be used as visual dimension fields. They can only be used as value fields. So you need a table column as a dimension field, which can provide segmentation/filter for other measures. 

For example, I add a Group table which only has values 1 and 2. These two values will be used in other measures to provide different calculations for two groups. To show ">=X" and "<X" values, I use a measure and a what-if parameter. 

So the result is similar to below. 

The problem is that the Group column cannot be removed from the table visual. It should be there to act as a dimension field because all other measures cannot do that job. I have attached a sample file at bottom. Hope this would be helpful. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.