How to hard code SALES_ Field with amount is not zero ?

[admin11]

Hi All

I have a chart witht eh help from @v-yetao1-msft  , ailsa advise me add filter panel with sales is not 0 , it work fine. now i like to hard code this into my SALES_ Field :-

I have try :-

SALES_AILSA = if([SALES_]>0, SUM('SALES'[sales]))

it cannot work , hopoe some one can advise me where go wrong ?

mY pbi FILE :-

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

Paul

[Ashish_Mathur · Accepted solution]

Hi,

Revised your target measure to:

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

Hope this helps.

[admin11]

@Ashish_Mathur 

thsnk you very much 

[Ashish_Mathur]

You are welcome.