Remove filter in calculation group

[Anonymous]

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 have tried to use removefilters() on my percentage measure, but it doesn't have any effect. Is there some way i can add the filter in my calculation groups table, so it doesn't affect this percentage filter? 

I use the selectedmeasure() just in my calculation group. Hope somebody can help with this. 

[BrunieToons]

Related to AmiraBedh's post, Alberto did a short vid on it: ISSELECTEDMEASURE – DAX Guide - SQLBI
I think I am trying to do the same thing you are and it worked like a charm.

[AmiraBedh]

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().

[amitchandak]

@Anonymous , Based on what I got , you have to create another calculation group like

Divide([selected measure], calculate([selected measure], removefilters(Table) ) )