Measures in PBI Line Chart not displaying intended sum.

[htbull_]

Hello all, 

I am encountering an issue where the measures that I have created are totaling across several years within a line chart. I am intending to only display the total amount for each of the years provided.
(ex. The brown line listed below is totaling as .36 for 2023 and .60 for 2024 - would like to only display the .51 total for 2024)

There were multiples measures created due to the criteria for each year, and they are all tied to an external date table. 

(ex. 2024 Attachment Point Trend = [2024 Att Points ] / [2024 GL Count])

2024 Att Points = CALCULATE(
COUNT('Policy Current Info'[c_2024 xs 35mill Total Attachment Points]),
FILTER('Policy Current Info', 'Policy Current Info'[c_2024 xs 35mill Total Attachment Points] = "true"),
USERELATIONSHIP('Policy Current Info'[Policy Year], 'Calendar'[Date])
)

2024 GL Count = CALCULATE(
COUNT('Policy Current Info'[c_IsInForce2024 - GL]),
USERELATIONSHIP('Calendar'[Date],'Policy Current Info'[Policy Year]),
FILTER('Policy Current Info', 'Policy Current Info'[c_IsInForce2024 - GL] = "In Force")
)

[htbull_]

Thanks for the help @v-ssriganesh. I was able to piece it together using the sample file that you provided. The measure summary worked perfectly. 

[v-ssriganesh · Accepted solution]

Hello @htbull_,
Thank you for reaching out to the Microsoft Fabric Forum Community.

I have reproduced your scenario in Power BI, and I was able to achieve the expected output as per your requirements. The line chart now displays the total "Attachment Point Trend" for each year (0.30 for 2021 and 2022, 0.38 for 2023, and 0.51 for 2024) without showing intermediate values like 0.36 or 0.60.

To resolve the issue, I made the following adjustments:

• Updated the Att Points measures to use COUNTROWS instead of COUNT, as the COUNT function does not work with Boolean columns.
• Ensured the GL Count measures correctly filter by the respective year to avoid over-counting.
• Created a summary measure, Attachment Point Trend Total, to display only the yearly totals in the line chart.
  
  

Output:

For your reference, I have attached the .pbix file containing the solution. You can review the measures, data model, and line chart setup to see how the expected output was achieved.

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.