Forum Discussion
Measure returning majority category
Hello, I'm trying to categorize my products based on Sales and Cost conditions. Based on the majority of the products category, we are then categorizing the manufacturer. This is...
SabineOussi no, star schema will improve the performance, right now it is scanning 1.7 m rows for each manufacturer, if we have a separate manufacturer dimension, it will be small and the scan time will be way little. These are the basics of data modeling and best practices for power bi.
parry2k You're absolutely right about that, my whole model is actually based on a star schema.
For some reason I was thinking of something else.
In all cases, I tried the measure on the manufacturer from the other table. Results are consistent however performance is still the same.
Any other suggestion?
Thanks,
Sabine O.