Forum Discussion
Remove filter in calculation group
Hi, I have a calculation group made in Tabular Editor. I use it for display units and it works fine on my measures. But when i do a Percentage calculation, it should not work on those measures. I ha...
Try to use `ISSELECTEDMEASURE` function within your calculation group's table. It allows you to check whether a specific measure is currently selected and apply different logic based on the result.
Here's an example of how you can use the `ISSELECTEDMEASURE` function in the calculation group table to exclude measures from the calculation group's effects:
Here's an example :
MyPercentageMeasure :=
IF ( ISSELECTEDMEASURE ( 'MyModel'[MyPercentageMeasure] ), 'MyModel'[MyPercentageMeasure], BLANK() )
This formula checks if "MyPercentageMeasure" is selected and returns its value. If it is not selected, it returns BLANK().