Giving the limitation of the ability to use measures as a slicer, is there is best practices or techniques that would allow this? if yes, is it possible to add it to the structured lessons or the mini-series, please?
I have no specific scenario or examples for now but assuming I am working with a DW that holds millions of rows. Some of the columns would hold categories or account types which for sure would be repetitive or duplicates for each customer. Grouping each column will add a great benefit to the model, but what is the best way in:
- Direct Query