Forum Discussion
Solved
Measure wrong total in Matrix Visual
Hi I Ran in to issue with totals in Matrix visual when I hide values in Target row as per user request when we don't have values in Actuals , I looked up many posts and tried all but it was not wo...
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 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
Thanks Aj and Rena
I created measure using solution from other thread Aj suggested . Thank you both
Suresh