Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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.
Thank you for your response, I tried this, but it didn't work. Please let me know if I'm overlooking something.
There was also the part where you use the variable in a IF confition, replace "return dPcsXX" with:
return
if ( isblank(dPcsXX), "N" , "Y")
959473AA should be "N" since the pcs-US value is 0 but it is "Y"
Replace it with this:
if ( or(isblank(dPcsXX),dPcsXX=0), "N" , "Y")
Now 39993BB should be "Y" since the pcs-US value is 3
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?
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.
Glad I was able to help!
User | Count |
---|---|
106 | |
86 | |
81 | |
73 | |
71 |
User | Count |
---|---|
111 | |
102 | |
97 | |
74 | |
67 |