All Function not working

[JenniferWallace]

CALCULATE(

    SUM(Table[marks]),

    FILTER(

        Table,

        Table[grades] = "Average"

    ),

    ALL('Calendar'[year])

Why is my  ALL('Calendar'[year]) not working, I want it to not be affected by this Calendar

year slicer

@Dangar332 @v-cherch-msft 

[Dangar332 · Accepted solution]

hi, @JenniferWallace 

you can use edit interaction

please visit HERE 

[mlsx4]

Hi @JenniferWallace 

You can do this:

Measure = CALCULATE(
    SUM(Table[marks]),ALL('Calendar'[year]), Table[grades]="Average")

[mlsx4]

@JenniferWallace have you tried this?

If both tables are related, it should work

[Dangar332]

Hi, @JenniferWallace 

you use AlLL() as a calculate modifier which remove filter context not ignore outer filter 

for ignoring outer filter you must usr ALL()  as  a  table function.
for more dive in ALL() function refer HERE 

sumx(
   filter( 
     all('table'),    --- use as a table function so ignore outer filters
     table[grades]="Average"
   ),
   Table[marks]
 )


or 

CALCULATE(
    SUM(Table[marks]),
    FILTER(
        all(Table),
        Table[grades] = "Average"
    )
 )

[JenniferWallace]

Hi @Dangar332 ,

I understand this issue, But the thing is, my filter table and calendar table is different, so how should i accomodate the filter from 2 different tables and use ALL as a table function

[Dangar332]

Hi, @JenniferWallace 

try below

CALCULATE(
     SUM(Table[marks]),
     FILTER(
        all('Calendar'),
        X  -- use column name which participate in relationship b/w tables(table and calender)
     ),
     'table'[grades]="Average"
    )