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

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.