Forum Discussion
IntaBruce
Resolver I
Resolver IDynamic Filtering
I wasn't sure what to call this thread because it's difficult to explain in a few words. Here is my challenge: I want to build reports on a Fact Table called ExhibitWorkOrder, and I want to filter ...
This is hard to solve because the data you need simply isn’t there. The best you can do is anticipate the type based on keywords in the description, but even that won’t always be reliable. DAX and M have limits — without a clear underlying logic to identify each type, there’s only so much they can do.
vivmueller
Kudo Kingpin
Kudo KingpinIs it possible to use a logical ID for the Exhibit Type column? Like instead of only 1, 2, 3... then to use MD-01 (mobile devices), CD-02 (computer devices) and so on? So anytime new devices are added, you directly add this information to the row.