Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Table values not displays values after making sum of fields

Hi everyone,   I need some solution for one of my work in PowerBI,   Question:  how to display all field value from Table A  after using summarize data from other tables<table 1,2,3> what is iss...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

If I understand correctly, you would like to get a summarized table with all fields values from table A, table B, table 1, table 2 and table3. You can refer the following links to get it:

1. By Power Query

Append vs. Merge in Power BI and Power Query

Power BI combine columns from two tables

2. By DAX

Combine Tables or Create Relationships? The Power BI Modeling Best Practice

Combining Tables in Power BI: Union, Except, and Intersect in DAX

UNION(Table1,Table2)

If the above ones can't help you get the expected result, 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 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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

 H Anonymous , Thanks for valuable reply. But still I find it was different scenario. I have attached screenshot below.hope this give better idea. If not let me know i change the option

* for some technical reason i could not upload my any excel or pbix outside of my computer.

 Thanks 

M Logendrn

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      OMG Thanks Anonymous . It works for me. I thought I missed something simple, but your work shows it was my fault. Great. Thank you once more for reproducing and sharing my samples in PBI.