Forum Discussion
Measure wrong total in Matrix Visual
Gotcha
check this out, here is the solution
Hope this will help
Hi venkatasuresh_g ,
You can create another measure based on the measure "Target_Mes" to get total value and put the new measure on the visual to replace the original measure "Target_Mes":
NTarget_Mes = SUMX(VALUES(D_Date[MonthYear]),[Target_Mes])Best Regards
Rena
Hi Aj,
Thanks for your time.
Even when I use month year from Target table I am not getting the results as expected , Total for Target row is still 81 , I was expecting 47 as I am showing only JAN and FEB month data . When I use Month from Target table it is showing Taregt for MAR as well in the table , which I don't want as I don't have actuals for MAR.
My problem with is just with total column rest all good.
Thanks
Suresh
Gotcha
check this out, here is the solution
Hope this will help