Why Target Amount not link with my SAL_C ?

[Paulyeo11]

Hi All

My Target amount by SAL_C is me wrong result :-

My sales table and target table is link by :-

Source & Group =

DISTINCT (

UNION (

SUMMARIZE ( SALES, SALES[SOURCE], SALES[SAL_C_] ),

SUMMARIZE ( TARGET, TARGET[SOURCE], TARGET[GROUP_] )

)

)

Hope some one can share with me where go wrong ?

https://www.dropbox.com/s/x2abyjcnbclw812/PB_TDS_V018.pbix?dl=0

Above my PBI file

Paul

[v-jingzhang · Accepted solution]

Hi @Paulyeo11 ,please check the PBIX file. I modify the relationship between Sales table and Source&Group table, and then add a filter to the table visual to filter out blank SAL_C values. 

Result: 

Best Regards,

Community Support Team _ Jing Zhang

If this post helps, please consider Accept it as the solution to help other members find it.

[Paulyeo11]

Hi Jing

How you modify the relationship sales table and link brigde table ? 

Paul 

[v-jingzhang]

@Paulyeo11 Create a relationship like below.

Jing

[Paulyeo11]

Hi Jing

Thank you for your help in sharing the relationship.

I Try to follow your advise , But i still not able to make it work :-

my PBI file

https://www.dropbox.com/s/m5mi557c7lyycg5/PB_TDS_V039%20ask%20Jing.pbix?dl=0

Hope you can advise me.

Paul

[Paulyeo11]

Hi Jing

Thank you very much

Paul

[Anonymous]

@Paulyeo11 Find the pbix here  and see if that's the required result.

[Paulyeo11]

Hi Sir

Thank you very much for sharing , my expected result as below , Hope you can create and share with me.

[Anonymous]

Hi @Paulyeo11 ,

The issue is with your data model. 

There is no link between Sales Table and Target Table, due to which you are getting same target amount for all SAL_C(from Sales Table) values.

I can see you created a new table with unique values from both Sales and Target Table. Make a relationship between "Source & Group" table and Target table(already created, but try to make it 1 to many not compulsory but recommended), with filter direction, "Source & Group" table filters Target Table.

Similarly create a relationship between "Source & Group" table and Sales table(try to make it 1-many as well not compulsory but recommended), with filter direction, "Source & Group" table filters Sales Table.

Once this is done, use the SAL_C column from "Source & Group" table, you shall have the expected result.

Romil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[Paulyeo11]

Hi Romi

I have try to link the Sales Table field on SAL_C_ with my link Table SAL_C , but the result still the same. Can you help me by share the working PBI file , since you already know where go wrong ?