Forum Discussion

admin11's avatar
admin11
Memorable Member
5 years ago
Solved

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

Hi All

I have a chart witht eh help from Anonymous  , 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

 

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    Revised your target measure to:

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

    Hope this helps.