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:
Appreciate your help. It’s interesting how BI users find workarounds. In my case, I was interested in finding best practices to apply in Direct Query & Import.
To the contributors of this post, thank you for all your inputs on this topic we are now tagging it as Solved. To help us learn more about your experience in the forum, please take a moment to answer this short forum survey. We appreciate all your help and suggestions. Thanks!