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

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'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