Forum Discussion

BartVW's avatar
BartVW
Icon for Helper I rankHelper I
4 years ago

Many-to-many dimension - blank row behavior

hi all In my data set, i have a fact table that has a many-to-many relation to a dimension table.  Fact table has a foreign key to the dimension table, and eg sales amount as a measure. Dimension ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Would this make sense? This way you can avoid many to many relations

 

 

  • BartVW's avatar
    BartVW
    Icon for Helper I rankHelper I
    4 years ago

    I don't think so. In my data, the measure (price in your example) is linked only to a warehouse task, not to the combination of warehouse task and service code. I think that if I implement your solution, I would double count those cases where a warehouse task has more than 1 service code.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Yes but that would be as well a facts table, (WarehouseTasks) and woul make a distinctcount and create measures on top of that distinctcount measure.

       

      If you want, you could share you pbi file and i could provide an example

      • BartVW's avatar
        BartVW
        Icon for Helper I rankHelper I
        4 years ago

        Thanks. I can try and prepare a mockup pbix with my scenario. But before I do: will your solution also work for those cases where there is no service code at all? Would that introduce records with a blank key in the fact table? And is it really best practice in power bi to handle this through a measure (it cannot be distinct count as I need to be able to sum up the quantities)?