Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Summarize Expression Result in Table Visual

Hello PBI Community Members, I need your help understanding why identical summarize expression is producing 2 different table results.  The summarize expressions use data from the 2 different tables ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hello Marik, I resolved my issue w/ a table redesign and new approach to creating the table and matrix visuals.  Thanks for the help.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Anonymous Check out whether you use 'Make' field from right table.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello Marik, yes in the bad result I am using the 'Make' field and hierarchy from the Equipment Inventory Detail table.  This seems correct.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Then try to wrap those AVERAGE functions in CALCULATE().

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Wrapping the average functions w/ calculate did  not change the output....

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hello Marik, I resolved my issue w/ a table redesign and new approach to creating the table and matrix visuals.  Thanks for the help.

      • v-xiaotang's avatar
        v-xiaotang
        Community Support
        4 years ago

        Hi Anonymous 

        Thanks for your solution. Could you mark your answer as the solution to help others find it easier? 

         

         

        Best Regards,

        Community Support Team _Tang

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