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 referenced below creating 2 config tables which contain identical content.  The made tables are correct but pulling the config averages into a table visual is producing the 2 different results shown below -- very puzzling.  Thanks for any help you can provide.

 

Good result using table "eq availability"

Bad result using table "equipment inventory detail" (slightly different data)

 

  • 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.

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      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

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