How to remove those row no sales amount using script ?

Hi All

My below script is working fine , it allow me to add in new brand :-

BRAND_N =

IF ( 'SALES'[BRAND_5] = Blank(),

"No Brand",if(SALES[BRAND_5] in

{"HMS","HAKKO","BECKHOFF","EMERSON","MITSUBISHI","MSA","REDLION","UNIVERSAL","GE","PROJECT","NON ","INTERNAL","MOOG","ABB","PARKER","INTERNAL ","INTERNAL ","INTERNAL ","INTERNAL ","ROBOTIQ"},

'SALES'[BRAND_5], "Other"))

My question is how to modify the above script , so that it will smart enough only display those Brand which have sales value.

Paul

Need Help

parry2k
4 years ago
admin11 not sure why you are using ISBLANK

Sales Vari % = divide( [Sales YTD]-[Sales LYTD], [Sales LYTD] )

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

11 Replies

parry2k
Super User
4 years ago
admin11 not sure why you are using ISBLANK

Sales Vari % = divide( [Sales YTD]-[Sales LYTD], [Sales LYTD] )

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
- admin11
  Memorable Member
  4 years ago
  parry2k
  Thank you , your script work fine.
  ALLUREAN
  Thank you for your help , after change the sales % vari , it work fine now.
- ALLUREAN
  Solution Sage
  4 years ago
  In that case you are right and this will ignore empty values, just tried to understand the % measure logic
ALLUREAN
Solution Sage
4 years ago
Hi, admin11

One way to achieve this is to set IFISBLANK condition in your % measure, so 100% should dissapear from this table
- admin11
  Memorable Member
  4 years ago
  ALLUREAN
  Thank you for sharing. As my script is a bit complicated , and i am not sure where to insert the condition . Are you able to help me ? Thank you in advance.
  - ALLUREAN
    Solution Sage
    4 years ago
    What is your Sales Vari % measure?
- admin11
  Memorable Member
  4 years ago
  ALLUREAN
  My Table have 3 column , YTD LYTD and Vari % see below image :-
  - ALLUREAN
    Solution Sage
    4 years ago
    Can you paste the code for Sales Vari %? And if you remove it from the table, is the empty brands also are not showing?
parry2k
Super User
4 years ago
ALLUREAN doesn't make sense why check for blank() when you are returning blank(), doesn't make sense at all?

Just my 2 cents.

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

Forum Discussion

How to remove those row no sales amount using script ?

11 Replies

Related content

Power Query Add rows of zero amount

How to remove duplication of sum amount

remove duplicate value within a row

Error in Script Activity with Script parameters

Removing Duplicates