I need to visualize the sum of a column in a related table to give row by row values, total value

[Islam30]

I have 15 tables with a unique column representing the building name, each table has the same headings (e.g. DIV02:DIV17) plus the total for all rows. I made one of the tables as a Fact and I built one to many connections with others

For example, I used the following measure in one of the tables to give building by building value, but whether it gives me blank or only total or the same total at each row.

Measures used as follows:

- Calculate&SUM = CALCULATE(SUM(PKA_Total_Cumulative_Payments_78[DIV02]))

- Calculate&SUMX = CALCULATE(SUMX(FRevised_Contract_Amount_78,RELATED(PKA_Total_Cumulative_Payments_78[DIV02])))

- Sum = SUM(PKA_Total_Cumulative_Payments_78[DIV02])

Also, SUMX without calculate

Note, In fact table I combined the BLD and Description Columns into Full Name and then I made connection

So, please I need advise on how to make a distinct unique value at each row plus total value

[Anonymous · Accepted solution]

Hi @Islam30 ,

If I understand correctly, there are 15 tables with the same table headings. And you create the relationships for these tables in your model, but it return the blank values for the field [full name] when apply the measure onto the visual... Am I right? If yes, I think you can refer the following links to append these tables with the same headings in Power Query Editor first, then create measure and create visual to get the expected result...

Append queries - Power Query | Microsoft Learn

Combine or Append Data in Power BI / Power Query: Main Concepts — The Power User

If the above one can't help you, could you please provide some raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards