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 issue

I have issue on displaying all ID's from Table A irrespective in a Table Visual while using the summary option.

 

Above is the picture i have noted with relationships

Table A  - main table contains ID field but no P.name columns to relate table 1,2,3

Table B - intermediate table to relation with Table A and table 1,2,3 which has both ID and P.Name

Table 1,2,3 - table contains P.Name but not ID and values respective with P.Name

I need to visuals as like below

ID is common and Region is column in Table A and which is not in other tables

My issue is table 1,2,3 have only region A values and not B and C. while adding the fields <table 1 vlaue,table2 value, table2 value> into table visuals i need to summarize the data since it have non unique P.Name. 
if i use Dont summarize option i will getting all Region Values but for Region A, I'm getting repeated values since it is non-unique values

If i summarise the values <in order to get single line value> I'm not getting values for Region B and C. 

 

Sorry for my english written but hope you understand the scenario.

 

Kindly any one help me what action i need to use. is the issue with relation or functionality

 

FYI: I could not use grouping here because I filtering the vlaues with Date field in table1,2,3

 

Thanks 

M Logendran

4 Replies