My sales vs Target still unable to get it solve ?

[Paulyeo11]

Hi All

I still unable to figure out why my sales vs target still not able to work.

My PBI File :-

https://www.dropbox.com/s/5lsgp4wns4lxpws/PB_TDS_V035.pbix?dl=0

[jaideepnema]

@Paulyeo11 

If i understood the issue properly please Create a table as shown below

Now join the sales and target table using the group column with this table as shown below

Now use this group table which you have created to show the sales ytd and target YTD measures

Appreciate a Kudos if this resolves your query !!

[Paulyeo11]

Hi Jai

I have follow all your step , i still unable to get it link. 

Group =

DISTINCT (

UNION (

SUMMARIZE ( SALES, SALES[GROUP_] ),

SUMMARIZE ( TARGET, TARGET[GROUP_] )

)

)

And i link the GROUP Table field GROUP_ with sales Table and Target Table.

My PBI file :-

https://www.dropbox.com/s/80b997adcoqkzv8/PB_TDS_V046.pbix?dl=0

Paul Yeo

[Paulyeo11]

Hi Jai

Thank you very much. For your detail explain .appreciate very much.

[amitchandak · Accepted solution]

@Paulyeo11 , Create a Key Source+ group in Sale and Target. Added that to source and group dimesnion. Join both tables with dimesion. Used the group from dimesnion.

Check the file attached

[Paulyeo11]

Hi Amit

Thank you very much. 

I have created all that like what you said , but then still not working . now i see that you make it work . may be you can share with me what you do ?

Paul