Measure wrong total in Matrix Visual

[venkatasuresh_g]

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 

[aj1973 · Accepted solution]

Gotcha

check this out, here is the solution

https://community.powerbi.com/t5/Desktop/visual-total-not-matching-sum-of-individual-row/m-p/1183586...

Hope this will help

[aj1973]

Hi @venkatasuresh_g 

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 

[venkatasuresh_g]

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 

[aj1973]

yes it is clear and i just edited my previous reply.

let me know if it is clear for you!

Thanks

[venkatasuresh_g]

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 

[v-yiruan-msft · Accepted solution]

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

[venkatasuresh_g]

Thanks Aj and Rena 

  I created measure using solution from other thread Aj suggested . Thank you both 

Suresh

[aj1973 · Accepted solution]

Gotcha

check this out, here is the solution

https://community.powerbi.com/t5/Desktop/visual-total-not-matching-sum-of-individual-row/m-p/1183586...

Hope this will help