I can replace the logic of REMOVEFILTERS in something else?

[netanel]

Hi All,

In my case, doubling the DIM tables in order to use them as independent columns in the same visual, i used the following Measures

Column A = CALCULATE(SUM(Epm_Fct[Amount_N]),

REMOVEFILTERS('EpmScenarioDescAll'[Scenario]),

REMOVEFILTERS('EpmVersionDescAll'[Version]),

REMOVEFILTERS(EpmPlanElement[PlanElementLvl1],EpmPlanElement[PlanElementLvl2],EpmPlanElement[PlanElementLvl3],EpmPlanElement[PlanElementLvl3],EpmPlanElement[PlanElementLvl5],EpmPlanElement[PlanElementLvl6],EpmPlanElement[PlanElementLvl7],EpmPlanElement[PlanElementLvl99] ),

Column B = CALCULATE(SUM(Epm_Fct[Amount_N]),

REMOVEFILTERS('EpmScenarioDescAll (2)'[Scenario]),

REMOVEFILTERS('EpmVersionDescAll (2)'[Version]),

REMOVEFILTERS('EpmPlanElement (2)'[PlanElementLvl1],'EpmPlanElement (2)'[PlanElementLvl2],'EpmPlanElement (2)'[PlanElementLvl3],'EpmPlanElement (2)'[PlanElementLvl4],'EpmPlanElement (2)'[PlanElementLvl5],'EpmPlanElement (2)'[PlanElementLvl6],'EpmPlanElement (2)'[PlanElementLvl7],'EpmPlanElement (2)'[PlanElementLvl99] ),

REMOVEFILTERS('Dim_Time (2)'[DateVal].[Date],'Dim_Time (2)'[DateVal].[Day],'Dim_Time (2)'[DateVal].[MonthNo],'Dim_Time (2)'[DateVal].[Month],'Dim_Time (2)'[DateVal].[QuarterNo],'Dim_Time (2)'[DateVal].[Quarter],'Dim_Time (2)'[DateVal].[Year]))

REMOVEFILTERS(Dim_Time[DateVal].[Date],'Dim_Time'[DateVal].[Day],Dim_Time[DateVal].[MonthNo],Dim_Time[DateVal].[Month],Dim_Time[DateVal].[QuarterNo],Dim_Time[DateVal].[Quarter],Dim_Time[DateVal].[Year]))

pay attention
That in column B there is (2) which is actually the same table as in measure A
just doubled

I want to replace the logic of REMOVEFILTERS
to something else
Since I insert more columns it no longer works

I would appreciate your assistance

Thanks

[tamerj1]

Hi @netanel 
You can use ALLEXCEPT, it will remove all the filter from all the columns from atable except the ones indicated in the argument.

[netanel]

Hi @tamerj1 

I thought about it but it's a problem
Because I want each user to be able to choose what they want in any given column
without damaging the rest of the columns

[AlexisOlson]

I don't follow. What columns are the users choosing? The same or different columns that you're removing filters on?

In general, how do you decide which columns to REMOVEFILTERS and which ones not to?

[netanel]

Hi @AlexisOlson 
The same columns of filters

The report looks like this, there is an option to filter each column according to its filters

I will expand
I created a column selection in filters
There are currently two columns and two sets of filters to filter the columns
The user chooses
Date for the report
version of a report
scenario for the report
and Plan element for the report
and the column changes accordingly

What I did was create duplicates of the following DIMS
Date
version
scenario
Plan Element
And my Measure refers only to the first DIM and Removefilters ignores the second DIM (2)

Now I want to create more columns but I don't want to double the DIM the third and fourth time
That's why I want to change the logic of RemoveFilters

[AlexisOlson]

You can use REMOVEFILTERS on entire tables rather than just columns.

So for example, 

Column A =
CALCULATE (
    SUM ( Epm_Fct[Amount_N] ),
    REMOVEFILTERS ( DateB ),
    REMOVEFILTERS ( ScenarioB ),
    REMOVEFILTERS ( VersionB ),
    REMOVEFILTERS ( PlanElementB )
)

Column B =
CALCULATE (
    SUM ( Epm_Fct[Amount_N] ),
    REMOVEFILTERS ( DateA ),
    REMOVEFILTERS ( ScenarioA ),
    REMOVEFILTERS ( VersionA ),
    REMOVEFILTERS ( PlanElementA )
)

[netanel]

@AlexisOlson Thanks
I thought about it, don't know why I didn't implement it
But now I updated mine

Column A = CALCULATE(SUM(Epm_Fct[Amount_N]),

REMOVEFILTERS('EpmScenarioDescAll'),

REMOVEFILTERS('EpmVersionDescAll'),

REMOVEFILTERS(EpmPlanElement),

REMOVEFILTERS(Dim_Time))

Column B = CALCULATE(SUM(Epm_Fct[Amount_N]),

REMOVEFILTERS('EpmScenarioDescAll (2)'),

REMOVEFILTERS('EpmVersionDescAll (2)'),

REMOVEFILTERS('EpmPlanElement (2)' ),

REMOVEFILTERS('Dim_Time (2)'))

What do you think about the rest of the case?

[AlexisOlson]

That looks a lot more maintainable now.

I'm not sure what "the rest of the case" is.

[netanel]

@AlexisOlson 
As I wrote above
I am trying to replace the removefilters logic
So that I can add more columns to my table

[AlexisOlson]

Sorry. I still don't follow.

If you add additional columns to the existing tables, this method should still work since it's removing all filters on the tables (including any new ones).

[netanel]

@AlexisOlson 

Please see that column A gat data form dim and column B get data from other Dim (2)

And the removefilter intract them saprdly

So if whant more clomun i need to creat more Dim

That the reason i whant the replace the remove filter