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
Can you please better explain your issue!
I have your sample and in my understanding your are running issue with the dates as your Target and Actual have different days but you are using in your visual only one date from the dimetable. The reason I am saying this is because your Target_mes is using 2 different Tables through their respective dates abd in your visual you are using dates from your Dimdate therfore there is an ambiguity. try to use the date from the target and you will get to see the data from Mars.
Thanks
Hi,
If you see the target Row in bottom Matrix table total is 81 as opposed to 47 , I displayed all the rest of the months in year as user wants to see full year always but user wants to see data only when Actual is available
Hope this is clear now
Thanks
yes it is clear and i just edited my previous reply.
let me know if it is clear for you!
Thanks
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
