Measure formula giving wrong total in matrix

[Anonymous]

Hi,

I have an issue with the total showing for nature is incorrect because i have a slicer with period_ID that has jan20 to jun20 month value and in same page i visualise the data in matrix with the hierarchy of nature_parent_1, nature_parent_2 and I have created measure for Current YTD but when I am selecting May20 month in period_ID so the total for nature_parent_1 is giving incorrect value, Because it is totalling all values for nature_parent_2 either if there are no amount for A1, A2 in May20 month so just I want that if I select May20 month in period_ID it should show the total only for  nature_parent_2 that has amount means it should not show the total of all

month data, Please refer attached screenshot.. As you can see for Feb20 period_ID A2 has amount 166831 so this is adding in total for Nature_Parent1 and giving May20 amount is 222785476 that I dont want to add if am selecting other month...Hope I clarify all the things....Please help me in this case...Thanks

[v-diye-msft]

Hi @Anonymous 

Your data is too scarce to point out the issue. you might refer to below similar threads for more hints:

https://community.powerbi.com/t5/Desktop/Measure-wrong-total-in-Matrix-Visual/m-p/1193555 

https://community.powerbi.com/t5/Desktop/visual-total-not-matching-sum-of-individual-row/m-p/1183586#M532054 

https://community.powerbi.com/t5/Desktop/Matrix-measure-totals-are-wrong/m-p/1056696 

[amitchandak]

@Anonymous , With the screenshot, you issue is not clear. But in the case of YTD The Grand total will be YTD based on last month.

You can try something like this to check if you see the total

sumx(values(Table[Month-year]),[Ytd Measure])