Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

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

     

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

  • AmiraBedh's avatar
    AmiraBedh
    Super User
    3 years ago

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