Forum Discussion

nagaraj007's avatar
nagaraj007
Post Patron
6 years ago

Unable to display Total in Matrix

Hello All,

I have added one column named TARGET to the MAIN TABLE from other TABLE using LOOKUPVALUE (formula is also shown), how ever when i put the value in table matrix i am unable to get the TOTAL for the column. Please advice.

Need Help
Show and Tell

7 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    6 years ago

    nagaraj007

    try

    SUMX(SUMMARIZE(table_strategic objective), table [strategic objective], “target”, [target]), target)

     

     

     

     

    • nagaraj007's avatar
      nagaraj007
      Post Patron
      6 years ago

      I am unable to get the result as per the below query 

      Target1 = SUMX(SUMMARIZE('BSC Final','BSC Final'[strategic_objective_description],"ttarget",Actuals[Target]),[ttarget])
       
      Please advice
      • PaulDBrown's avatar
        PaulDBrown
        Community Champion
        6 years ago

        nagaraj007 

         

        Target1 = SUMX(SUMMARIZE('BSC Final','BSC Final'[strategic_objective_description],"ttarget",Actuals[Target]),[ttarget])

         

        Is the section highlighted in red your [target] measure?

        ( & the table and column reference in the SUMMARIZE function (in blue) must be the same as the one used in the visual for "Strategic Objective")

         

        Having said all that, It is slightly odd that you are using a LOOKUPVALUE function in this way. How is your data structured? Are the "Target" values and "Actuals from different tables? Do they have a common field (for example, "Strategic Objective")? can you set up a bridge table with a common field? etc etc

         

        If you can share your data structure and table structures (hiding confidential data of course) we might be able to provide a much more efficient solution.

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi nagaraj007,

    I test this in my environment which works well in Matrix. In addition, you said that the sumx(summarize())  function don't work in your environment, what output did you get currently? If possible, could you please inform me more detailed information(such as your sample data and your expected output)? Then I will help you more correctly.

    Please do mask sensitive data before uploading.

    Thanks for your understanding and support.
    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.