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

[Anonymous]

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!

[harshnathani]

HI @Anonymous ,

Try a measure like this

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

Regards,

Regards,

Harsh Nathani

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

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

[harshnathani · Accepted solution]

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!

[Anonymous]

@harshnathani 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!

[Anonymous]

@harshnathani Exactly what I needed, thank you!