topic Re: DAX to return true if our plant makes the sku or not. in DAX Commands and Tips

DAX to return true if our plant makes the sku or not.

Anonymous — Thu, 02 Jul 2020 14:14:46 GMT

Hello,

I have the following command in tableau:

(Fixed product_name: sum(IF [site_id] = "001" THEN [sale_unit] END))

I am trying to do something similar in power BI where I can recognize what product_names are made in our plant and sum the sale_units by matching it to our site_id.

Any idea on how I can achieve this?

Thanks in advance for your help!

Re: DAX to return true if our plant makes the sku or not.

Anonymous — Thu, 02 Jul 2020 14:22:02 GMT

HI Anonymous ,

Try a measure like this

Measure = CALCULATE ( SUM ( Table[Salesunit] ), ALLEXCEPT ( Table, Table[site_id] ) )

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution

Re: DAX to return true if our plant makes the sku or not.

Anonymous — Thu, 02 Jul 2020 14:29:52 GMT

Hi Anonymous ,

And incase you only want for site id 001.

Measure = CALCULATE ( SUM ( Table[Salesunit] ), Table[Siteid] = "001" )

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

Re: DAX to return true if our plant makes the sku or not.

Anonymous — Thu, 02 Jul 2020 14:37:20 GMT

Anonymous Exactly what I needed, thank you!

Re: DAX to return true if our plant makes the sku or not.

Anonymous — Mon, 03 Aug 2020 13:30:48 GMT

Anonymous I know it has been a while since this post, but do you know how we could to the flip of this. I want to see what our plant sends to other plants and see whether the site we send it to has the capability to make that sku.

I tried doing the flip of what we initially had for our home site with this:

_Site Produces = CALCULATE ( SUM ( 'table'[sales_unit] ), ALLEXCEPT('table','table'[prod_name]), 'table'[site_code] = "011", 'table'[site_code] = "018", 'table'[site_code] = "019", 'table'[site_code] = "020", 'table'[site_code] = "065")

I then created a conditional statement to check for T/F condition of production.

_Site Produces(T/F) = if([_Site Produces] <> 0, "True","False")

This however, is always giving me all false, dispite there being cases where it should be true. Is there anything I may be missing?

Thanks!