Forum Discussion

Pranali_R's avatar
Pranali_R
Frequent Visitor
2 years ago
Solved

All Function not working

CALCULATE(     SUM(Table[marks]),     FILTER(         Table,         Table[grades] = "Average"     ),     ALL('Calendar'[year])   Why is my  ALL('Calendar'[year]) not working, I want it to...
mlsx4's avatar
mlsx4
Memorable Member
2 years ago

Hi Pranali_R 

 

You can do this:

 

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

 

 

  • mlsx4's avatar
    mlsx4
    Memorable Member
    2 years ago

    Pranali_R have you tried this?

    If both tables are related, it should work