Forum Discussion

venkatasuresh_g's avatar
venkatasuresh_g
Helper IV
6 years ago
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...
Need Help
aj1973's avatar
aj1973
Community Champion
6 years ago

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

 

let me know if it is clear for you!

 

Thanks

venkatasuresh_g's avatar
venkatasuresh_g
Helper IV
6 years ago

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 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      venkatasuresh_g
      Helper IV
      6 years ago

      Thanks Aj and Rena 

       

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

       

      Suresh