How to link sales table and target table ?

[admin11]

Hi All

I have a Target Table :-

I have a sales table :-

i Have a SOURCE Table with below expression ( I think the expression not working ) :-

Source =

var _1=DISTINCT(UNION(all(SALES[SOURCE]), all(TARGET_[SOURCE])))

return

FILTER(_1,[SOURCE]<>BLANK())

I have SALES YTD expression :-

Sales YTD = CALCULATE ( [SALES_M],DATESYTD('DATE'[Date]))

I have TARGET YTD expression :-

Target YTD =

var _max = today()

return

calculate(TOTALYTD(('TARGET_'[TARGET_]),'DATE'[Date]),filter('DATE','DATE'[Date]<=_max))

My issue :-

My issue :-

Remark :-

- I have link the sales table SOURCE with SOURCE table SOURCE field.

- I have link the TARGET_ table SOURCE with SOURCE table SOURCE field.

- SALES and TARGET_ table Date field are link to master calendar

Paul

[amitchandak · Accepted solution]

@admin11 , Do you have common, Date, Staff and source tables ?

seem like target is joined with staff table

[admin11]

@amitchandak 

Thank you it work fine now. after i create the link table for STAFF :-

STAFF_SUB =

DISTINCT (

UNION (

SUMMARIZE ( SALES, SALES[STAFF_SUB] ),

SUMMARIZE ( TARGET_, TARGET_[GROUP_] )

)

)

paul

[admin11]

@amitchandak I don't have STAFF_SUB Table . STAFF_SUB field appear at SALES & TARGET_ table.  Thank you look into my question.