Monthly Entitlement Amount for 3 categories and Bar chart with Constant line

[AartiD]

I have an excel file with monthly entitlement amount for 3 care settings ICU, OR & CSSD. I have imported excel file in Power BI. and create Bar chart with entitlement amount as constant line and data lables of constant line changes as and when care settings is selected from filters in Power BI. The bar will be showing monthwise sales of 2025 & 2026. Entitlement amount for 2025 & 2026 should be same & constant lines. Right now the total Entitlement amount is coming to 49 Millions which is incorrect , it should come to 43 millions (I checked the file i have uploaded amount is correct in file)  and when i select care settings in fileter  Entitelemnt amount is not changing it is constant.

Measure used for Entitelement :-

Total Entitlement = CALCULATE(MAX('Entitlement-KA&EM 2026'[Value]))

Entitlement Files looks like this

[v-veshwara-msft]

Hi @AartiD ,

We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.

[v-veshwara-msft]

Hi @AartiD ,

Thanks for reaching out to Microsoft Fabric Community.

Just wanted to check if the responses provided were helpful. If further assistance is needed, please reach out and provide sample data without any sensitiuve information or sample .pbix file that resembles your scenario to assist better. You can upload your files to any cloud storage location like OneDrive or GoogleDrive and share the link here with permissions to download.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Thank you.

[DanieleUgoCopp]

Hello,

I’m not completely sure, but the issue looks like your measure is ignoring the filter context, using MAX like that will just return a fixed value instead of reacting to slicers. You could try wrapping it with something like CALCULATE but keeping filters, or switch to SUM if the entitlement should aggregate, also check if there’s any relationship missing between your entitlement table and the care settings, that’s a common cause. Another thing to test is using ALL or REMOVEFILTERS carefully, sometimes they lock the value without you noticing.

Best regards,
Daniele

[mickey64]

If you calculate the maximum value in the "Value" column, you don't need "CALCULATE".

    Total Entitlement = MAX('Entitlement-KA&EM 2026'[Value])

Is it correct to calculate the maximum value for the "Value" column?

[Natarajan_M]

Hi @AartiD , Could you share the data model and the sample data/PBIX file resembling your model? To effectively replicate the scenario and determine why the data is totaling 49 million instead of 43 million, we need the data you are currently using.

Thanks