I'm new to Power BI and have come across this issue. In power BI i am working with a csv file called 'EUTaxonomyCSRD'. In the file I have a column called 'Location Name' that defines the location name and a column called 'Total Asset Value' that defines the asset value and year (the same throughout) note that I have multiple rows with the same name (and the same asset value) like so:

Location Name, Total Asset Value, Year London, 200, 2030 London, 200, 2030 London, 200, 2030 Paris, 300, 2030 Paris, 300, 2030 Paris, 300, 2030

I am trying to make a matrix that has the following fields:

Rows

• Location Name

Columns

• Year

Values

• need to make a measure that just gets the asset value for the location, did like so given the asset value stays constant for each location:

  TotalAssetValueCSRD = SUMX(
  VALUES(EUTaxonomyCSRD[Location Name]),
  MAX(EUTaxonomyCSRD[Total Asset Value])
  )

My issue with this is that the values for each row are correct when looking at my csv file, but the total value at the bottom of the matrix is wildly off. Not sure if anyone has come across this issue, and ChatGPT has been of no use whatsoever so any help is greatly appreciated :)