- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Current month scores
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
01-25-2025 04:45 PM | |||
12-11-2024 05:34 AM | |||
10-24-2024 08:00 PM | |||
01-18-2025 10:21 AM | |||
04-04-2022 12:50 PM |
User | Count |
---|---|
23 | |
12 | |
10 | |
10 | |
8 |
User | Count |
---|---|
16 | |
15 | |
15 | |
12 | |
10 |