I have a more complex scenario in Grouping than the one in Sam’s tutorial.
In this case, grouping need to be done based on Order value, yet Sales table has multiple lines per order. So a virtual (?) table has to be created in the calculated column.
Managed to create a physical table (Order Groups) where each order is assigned to an Order Group (based on the supporting table ‘Order Value Groups’) but cannot get that calculation in the Sales table where is needed.
On the other hand, is it better performance-wise, to keep that info on a new table? In this case, what relationships should be created with the sales table?
All suggestions will be much appreciated.
Sample Report v4b.pbix (31.5 MB)