Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Solved! Go to 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.
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().
Hello Marik, I resolved my issue w/ a table redesign and new approach to creating the table and matrix visuals. Thanks for the help.
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.
Wrapping the average functions w/ calculate did not change the output....
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |