cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
admin11
Post Prodigy
Post Prodigy

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

Hi All

I have a chart witht eh help from @Ailsa-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 :-

admin11_0-1619045825075.png

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

 

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User III
Super User III

Hi,

Revised your target measure to:

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

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

3 REPLIES 3
Ashish_Mathur
Super User III
Super User III

Hi,

Revised your target measure to:

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

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

@Ashish_Mathur 

thsnk you very much 

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors