Calculate Column based on slicer selection of another table

[dkg8]

Hi all,

Thank you in advance.

Tablename - MyStoreItemMaster

Tablename – MyStoreItemInventory

Relationship

I need to flag each ItemNo at the MyStoreItemMaster based on the pcs-XX columns, considering the Region Slicer User Selection, and irrespective of whether Inventory data exists for the ItemNo.

Note - MyStoreItemMaster does not have Region column.

User select - US

MyStoreItemMaster with new calculated column HasForecastUnits

User select - RG-CA

User select - RG-EU

User select - RG-UK

Could you please provide guidance on how to accomplish this?

[JohnnySaade]

Try creating a conditional measure that will flag your items like so:

add variable that will change dynamically the pcs column depending on your selection using SWITCH then use the measure

HasForecastUnits = if ( isblank(variable), "N" , "Y")

let me know if this worked or if you need help writing the switch variable.

[dkg8]

Thank you for your response, I tried this, but it didn't work. Please let me know if I'm overlooking something.

[JohnnySaade]

There was also the part where you use the variable in a IF confition, replace "return dPcsXX" with:

return

if ( isblank(dPcsXX), "N" , "Y")

[dkg8]

959473AA should be "N" since the pcs-US value is 0 but it is "Y"

[JohnnySaade]

Replace it with this:

if ( or(isblank(dPcsXX),dPcsXX=0), "N" , "Y")

[dkg8]

Now 39993BB should be "Y" since the pcs-US value is 3

[JohnnySaade]

Okay, question, the items under the RG-US region don't necessarily have values in the pcs-US column only ( item master table ), is it a typo or that's the normal behavior of the data?

[dkg8]

Hi @JohnnySaade 

I applied the same logic, but instead of SelectedValue, I replaced it with Filters, and it's now working. Thank you for your help and quick responses. I appreciate it.

[JohnnySaade]

Glad I was able to help!