Current month scores

[Sri_phani]

Hello, 

I am trying to add current month scores in the card visual using a measure. 

My dataset has columns - First touch resolution rate, Date and has a relationship with the Calendar table. 

Here is the measure I am trying to use: 

CM_Month Metrics =

VAR startdate = EOMONTH(TODAY(),-1)+1
VAR enddate = EOMONTH(TODAY(),0)
VAR CM_Firsttouch = Average('1_Core Raw data'[First Touch Resolution Rate])
VAR Calc = CALCULATE(CM_Firsttouch,FILTER('Calendar','Calendar'[Dates]>=startdate && 'Calendar'[Dates]<=enddate))
VAR CAL_2 = CALCULATE(CM_Firsttouch,PARALLELPERIOD('Calendar'[Dates],-1,MONTH))

RETURN
Calc

I tried to use 2 approches Cal, CAL_2. But both of them only give the total average of the metric instead of the monthly scores. Please help in this. 

Thanks, 

Srikanth

[Sri_phani]

@foodd 

Thank you for responding, I don't see an option to change the summarization. In my entire dashboard in all the pages for all the measure, I don't see the option. 

Am I missing anything here? 

[foodd]

In the Report Column Well, for each of the columns interested [1] , left click on each column down arrow to change the implicit measure from Average to Sum [2].

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.