Forum Discussion
KEEP FILTERS EXCEPT ONE
Hello!
I need to remove filter context for one table, and keep filter for the rest of tables.
How I can do this?
Thank youu!
Is not a solution. I think i find another solution:
#LoansAverageBalance =
VAR days = DATEDIFF( FIRSTDATE( DIM_DATE[DATE] ), LASTDATE( DIM_DATE[DATE] ), DAY ) + 1
VAR _RELATE_VALUE =
ADDCOLUMNS (
DIM_DATE,
"RelatedV", CALCULATE (
SUM ( FCT_BALANCES[GL_BALANCE_RON] ),
FILTER (ALLEXCEPT( FCT_BALANCES, DIM_CUSTOMERS[BUSINESS_LINE_BUDGET]) , FCT_BALANCES[DIM_DATE_ID] = VALUE ( DIM_DATE[LAST_WORKING_DATE_ID] ) ),
SINT[CATEGORY] = "LOANS",
SINT[DESCRIPTION] = "PRINCIPAL"
)
)
--var cust_val = ADDCOLUMNS(_RELATE_VALUE, "bl", FIRSTNONBLANK(DIM_CUSTOMERS[BUSINESS_LINE], ""))
RETURN
CALCULATE(
MAX( 0, -1 * SUMX ( _RELATE_VALUE, [RelatedV] ) / days + 0 ))
2 Replies
- amitchandak
Super User
Anonymous , You can use removefilters(Table)
Is not a solution. I think i find another solution:
#LoansAverageBalance =
VAR days = DATEDIFF( FIRSTDATE( DIM_DATE[DATE] ), LASTDATE( DIM_DATE[DATE] ), DAY ) + 1
VAR _RELATE_VALUE =
ADDCOLUMNS (
DIM_DATE,
"RelatedV", CALCULATE (
SUM ( FCT_BALANCES[GL_BALANCE_RON] ),
FILTER (ALLEXCEPT( FCT_BALANCES, DIM_CUSTOMERS[BUSINESS_LINE_BUDGET]) , FCT_BALANCES[DIM_DATE_ID] = VALUE ( DIM_DATE[LAST_WORKING_DATE_ID] ) ),
SINT[CATEGORY] = "LOANS",
SINT[DESCRIPTION] = "PRINCIPAL"
)
)
--var cust_val = ADDCOLUMNS(_RELATE_VALUE, "bl", FIRSTNONBLANK(DIM_CUSTOMERS[BUSINESS_LINE], ""))
RETURN
CALCULATE(
MAX( 0, -1 * SUMX ( _RELATE_VALUE, [RelatedV] ) / days + 0 ))
