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 ...
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 Check out whether you use 'Make' field from right table.
Hello Marik, yes in the bad result I am using the 'Make' field and hierarchy from the Equipment Inventory Detail table. This seems correct.
Then try to wrap those AVERAGE functions in CALCULATE().
Wrapping the average functions w/ calculate did not change the output....