Forum Discussion
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 working for my scenario , unless I am missing something so I crated a sample pbix with data and visual so that someone can shed some light and help me with it.
PBIX is exported here
https://app.box.com/s/2cswfueqhzut8flbll0zp7y45o9o5yqc
Can you please help me fix this issue.
Thanks
Suresh
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
7 Replies
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
