Forum Discussion

SIMMI's avatar
SIMMI
Frequent Visitor
3 years ago
Solved

Filtered table sum

Hi,   I was trying to get the sum of all the values recorded in the past 24 months. My knowledge with DAX is very basic. I have applied filters, but it's working at each row level. I want the filte...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , SIMMI 

    Thanks for the sample data you provide.

    Here are the steps you can refer to :
    (1)My test data is the same as yours.

    (2)We can create a measure like this:

    Measure = var _cur_month = MAX('Table'[MonthSummary])
var _pre_24month = EOMONTH(_cur_month,-25)
var _t = FILTER( ALLSELECTED('Table') ,'Table'[MonthSummary]>_pre_24month && 'Table'[MonthSummary]< _cur_month)
return
SUMX(_t , [Value])+0

    (3)Then we can meet your need:

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi , SIMMI 

Thanks for the sample data you provide.

Here are the steps you can refer to :
(1)My test data is the same as yours.

(2)We can create a measure like this:

Measure = var _cur_month = MAX('Table'[MonthSummary])
var _pre_24month = EOMONTH(_cur_month,-25)
var _t = FILTER( ALLSELECTED('Table') ,'Table'[MonthSummary]>_pre_24month && 'Table'[MonthSummary]< _cur_month)
return
SUMX(_t , [Value])+0

(3)Then we can meet your need:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly