Forum Discussion
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)
- Anonymous4 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
- AnonymousNot applicable
Anonymous Check out whether you use 'Make' field from right table.
- AnonymousNot 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.
- AnonymousNot applicable
Then try to wrap those AVERAGE functions in CALCULATE().