Forum Discussion

wlandry12's avatar
wlandry12
Frequent Visitor
4 years ago
Solved

Assigning a Production Route Status to AssemblyID

I am struggling to work out the logic for assigning an overall route status to production assemblies and display them in a table visual.   All assemblies are assigned a route that consists of speci...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may refer to my solution in this file.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

You are welcome.  In your original post, you never mentioned that you had multiple tables.  How would i be expetced to know that?  If you need my help, please share the link from where i can download your PBI file and build the table/slicers that you want.  I will write the measure.

wlandry12's avatar
wlandry12
Frequent Visitor
4 years ago

My apologies, I should not have expected you to know that. Fortunately, I was able to fix it using your original DAX measures by simply adding a filter for "Qty is not blank". Thanks again for your help!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    4 years ago

    You are welcome.