Forum Discussion
Measure formula giving wrong total in matrix
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...
amitchandak
Super User
Super UserAnonymous , 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])