Forum Discussion

gauravnarchal's avatar
gauravnarchal
Post Prodigy
4 years ago

Need help with Calculated Column or Measure

Hello - I need your help in creating a measure or calculated column   Show all invoice numbers and total Amounts in columns against each (Settlement) Auth. When there are multiple invoice numbers ...
Need Help
Show and Tell
TomMartens's avatar
TomMartens
Super User
4 years ago

Hey gauravnarchal, 

 

please consider remodeling your Power BI dataset. The concept of the model can be called Header/Detail style. The most recent article from the people of sqlbi.com is exactly mentioning this style/concept, and why it should be avoided: Header/Detail vs Star Schema models in Tabular and Power BI - SQLBI

Next to that, here you will find an introduction to data modeling in regards of Power BI data models: Model data in Power BI - Learn | Microsoft Docs

 

The many-to-many relationship will make the required measure (using the DAX function CONCATENATEX to create a string from the Invoice Numbers) expensive as you are traversing the relationships in the "wrong" direction.

 

Hopefully, this provides some new insights that will help to tackle your challenge.

 

Regards,

Tom