Forum Discussion
itchyeyeballs
Impactful Individual
8 years agoUsing dimension as header breaks all filter
Hi all, We have hit a problem with our data analysis, we have been using a measure to calculate the value for a previous period, it was woking fine until we introduced a dimension table and used ...
itchyeyeballs
Impactful Individual
8 years agoI think I answered my own query by using an extra all:
FILTER (
ALL ('MIT enrol_load_procedure_tbl'[Year_Cyear_Index], 'MIT enrol_load_procedure_tbl'[ayr],'MIT enrol_load_procedure_tbl'[cyear],'MIT enrol_load_procedure_tbl'[va_date]),
'MIT enrol_load_procedure_tbl'[Year_Cyear_Index]= yearx - 101
),
all(Dim_course_year[Course_year_link])
)However this stops working if I try to add an extra all() for a second dimension table
=VAR yearx =
MAX ( 'MIT enrol_load_procedure_tbl'[Year_Cyear_Index] )
RETURN
CALCULATE (
[FTE_Sum_End],
FILTER (
ALL ('MIT enrol_load_procedure_tbl'[Year_Cyear_Index], 'MIT enrol_load_procedure_tbl'[ayr],'MIT enrol_load_procedure_tbl'[cyear],'MIT enrol_load_procedure_tbl'[va_date]),
'MIT enrol_load_procedure_tbl'[Year_Cyear_Index]= yearx - 101
),
all(Dim_course_year[Course_year_link])
,all(Dim_date,Dim_date[Date_ayr])
)gives - Multiple table arguments are not allowed in the ALL function.