How to remove target line from May till Dec 2021 ?

[admin11]

Hi All

I have sales vs target chart it work fine. 

I like to remove those target line from May till Dec , because May till Dec no sales yet , so don't need to display.

@Ashish_Mathur have share with me below code , it try to check if SALES_ is not blank , then compute the target line. 

TARGET_ = if(ISBLANK([SALES_]),BLANK(),SUM(TARGET_[TARGET]))

Since the sales vs target gap chart is using below expression :-

Target YTD =

var _max = today()

return

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

So i try to convert the above expression to below :-

TARGET_YTD_ASHISG_ = if(ISBLANK([SALES_]),BLANK(),[Target YTD])

No error , but it does not work.

Hope some one can share with me where go wrong ?

My PBI file :-

https://www.dropbox.com/s/6e7uksvl4rrklh8/PBT_V2021_400%20SI_TI.pbix?dl=0

Paul Yeo

[Ashish_Mathur]

Hi,

I think this is happening because there is no relationship between the Source column of your Target Table and the Source column of your Source table.  I tried to create a relationship but could not.  Furthermore, i have also simplified some measures.  Download the PBI file from here.

[samdthompson · Accepted solution]

Hello, I downloaded your pbix and replaced the Sales_YTD with this: It works for me

Sales YTD =

var _max = date(year(today())-0,month(today()),day(today()))

var val = TOTALYTD(('SALES'[SALES_]),dateadd('Date'[Date],-0,year),'Date'[Date]<=_max)

return

IF(TARGET_[TARGET_ASHISG_]=BLANK(),BLANK(),val)