Forum Discussion

USABB_Data's avatar
USABB_Data
Helper II
7 years ago
Solved

Dynamic SUM IF Using Calculate

Hi,   I am looking to create a dynamic Sum If measure but cannot get it right.  I saw this topic, remove link because would not let me post , but still am having trouble.   Data   SLS_ID Fi...
Need Help
Show and Tell
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi USABB_Data ,

     

    You can try to create measure like DAX below.

     

    MF YTM = CALCULATE(SUM(Table1[Sales]),FILTER(ALLSELECTED(Table1),Table1[SLS_ID]=MAX(Table1[SLS_ID])&&Table1[Fiscal Period]<MAX(Table1[Fiscal Period])))

     

    Best Regards,

    Amy

     

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

     

v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi USABB_Data ,

 

You can try to create measure like DAX below.

 

MF YTM = CALCULATE(SUM(Table1[Sales]),FILTER(ALLSELECTED(Table1),Table1[SLS_ID]=MAX(Table1[SLS_ID])&&Table1[Fiscal Period]<MAX(Table1[Fiscal Period])))

 

Best Regards,

Amy

 

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

 

USABB_Data's avatar
USABB_Data
Helper II
7 years ago

Incredible, it worked perfectly!!  Thanks!!