Summarize Expression Result in Table Visual

[tsdick]

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]

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

[tsdick]

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]

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

[tsdick · Accepted solution]

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]

Hi @tsdick 

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.

[tsdick]

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