Urgent: Inconsistent Row Totals in Power BI Matrix Visual with Custom Logic for Start and End Month

Thanks lbendlin Yes this works! Thanks again for putting effort on solving this!

Hi @lbendlin 

As I mentoned earlier the logic is working as expected but Year_Month

column in the matrix table is not dynamically updating based on the slicer date selection. In your first approach the column was dynamically changing but in second approach everything works fine except dynamically displaying the year_month based on slicer selection. seems like in UIM measure we need to adjust the logic to dynamically dispaying the year_month based on selection.

Could you pls, revisit this to troubleshoot the issue and find a resolution? Thanks in Advance!

Hi lbendlin I created one more measure as below and used this in values section of Matrix. now the columns are displaying dynamically based on date selection. Do we have any other approach other than this ? We need to consider performance as well..

Not clear to me what your new question is. Maybe create a separate thread?  

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Hey Hi lbendlin My bad, It seems like I mistakenly tried modifying the logic. So year-months columns was not changing based on date slicer selection and to solve that I was trying out different apporaches using Isinscope functions. But now tried with your second approach without altering the code, I can see the expected result. Now all set, sorry for the confusions!

Hi lbendlin Pls. refer to the image below: 

The logic for starting month is not working as expected. For remaining monthis its working fine.

Example: selected dates = 2/6/2023 to 1/7/2023

2023-06 Total unit is 1 and for 1/7/2023 also Total unit is 1.

So now for the first month 2023-06 the expected output is 0.94 but this measure gives the result as 0.97 but for last month (1/7/2023) its giving the correct result.

As per my analysis for first month the logic should work as (Totalydaysinfirstmonth-selecteddayinfirstmonth) * totaldaysincalendartable. But the measure used in image calcualtes 30/31 instead of 29/31 for the june month. Could you pls check on the logic for first month alone keeping the rest of the month logics as same. Return same unit for middle of the months and for last month the logic should be Totalunits *(totaldaysinmonth -selectedday)

Hi lbendlin  Did you get chance to check on this one?