A question please
why you prefer to make every task a table with one row to be used for the measures and not just create the measure directly on any table specially the fact sales tables? does it gonna give an error if we created it in the fact sales table?
1 answers ( 0 marked as helpful)
It is considered a good practice to have a separate table that holds your measures. You can store them across many tables if this is what you prefer but a measures table on its own definitely is more advantageous over storing them across five different tables.