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.
gopy6243
Advocate IV
Advocate IVYes, you can do it.
Create a small disconnected table with your 3 groups (Mobile Devices, Computer Devices, Other), map each one to the ExhibitType values you want, and then use a measure with TREATAS to push that selection onto ExhibitType[ExhibitTypeDescription].
Your visuals will then filter ExhibitWorkOrder correctly without any hard-coding.