Forum Discussion
Assigning a Production Route Status to AssemblyID
Super User
Thanks for your response, Ashish. I tried using the DAX from your sample file in my report, but it appears to be incompatible with data from related tables. In the table visual I am using the Assembly Mark from the related Assemblies table instead of AssemblyID, which is more familiar to the user. I also have slicers for Job # and Sequence from two other related tables (Jobs & Sequences). Using your "Measure" measure as the status column in the table visual seemingly breaks the ability to filter with these slicers, as the full database of Assembly Marks now shows in the table visual.
Additionally, I would prefer to filter the stations by StationType = 0 rather than StationID<>24. This is because Field stations (StationType = 1) may be added in the future, and they should never be included in the Production status.
- Ashish_Mathur
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.
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
You are welcome.