Forum Discussion

flaviobdsti's avatar
flaviobdsti
Icon for Helper I rankHelper I
3 years ago
Solved

Filter based metric sum

Hi Guys! Please I need your help! I have two measurements, LAST MONTH and CURRENT MONTH, both measures group sales values by CODE. When I put the two measures together with the CODE field in a t...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    This measure works.  Download the PBI file from here.

    Measure = SUMX(FILTER(SUMMARIZE(CALCULATETABLE(VALUES('Table'[ID]),DATESBETWEEN(dimCalendar[Date],EDATE(MIN(dimCalendar[Date]),-1),min(dimCalendar[Date])-1)),'Table'[ID],"A",[CURRENT_MONTH],"B",[LAST MONTH]),[A]=0&&[B]>0),[B])

    Hope this helps.

flaviobdsti's avatar
flaviobdsti
Icon for Helper I rankHelper I
3 years ago

Thank you for answering my message

I created a .pbix file as an example. I put it in a repository, in the link below:

SAMPLE.PBIX 



 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

This measure works.  Download the PBI file from here.

Measure = SUMX(FILTER(SUMMARIZE(CALCULATETABLE(VALUES('Table'[ID]),DATESBETWEEN(dimCalendar[Date],EDATE(MIN(dimCalendar[Date]),-1),min(dimCalendar[Date])-1)),'Table'[ID],"A",[CURRENT_MONTH],"B",[LAST MONTH]),[A]=0&&[B]>0),[B])

Hope this helps.

  • flaviobdsti's avatar
    flaviobdsti
    Icon for Helper I rankHelper I
    3 years ago

    Hi Ashish Mathur,
    I hope someday achieve your level. Thank you so much for your help. Worked perfectly!

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      3 years ago

      You are welcome.  Thank you for your kind words.