Level of Detail

[MarcUrdang]

Hi

I have a column of values in one Table (Gross Profit) and another Table with, amongst other fields, a Date field and a Customer Name field)

The two tables have a many to many relationship. 

If I bring the value in against the date field you get the same value (which is the actual correct total of all the GP for that customer ) per month and not aggregated over the correct dates 

Can you advise?

I assumed it was someting like:  CALCULATE(TotalGP),ALL(CustomerName) .... or something like this

thanks
Marc

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example. If possible please share a sample pbix file after removing sensitive information.
Thanks

[MarcUrdang]

Hi amitchandak .. I will send you the link to the workbook this evening from my personal laptop .. we are not allowed to use Google Drive. Alternatively I could mail you if I had your email address.

tx

Marc