Forum Discussion
Aggregation on rows with user selected filters
Hello: I am trying to recreate an analysis done previously with QlikView: A sales offer includes five types of offer (depending on the team who worked on the offer), many features and a few version...
Yes, I am afraid I should go for the initial approach and get the combinations, and the grouping for each feature. What I really wanted to know is that there is no possibility of doing it with just measures as it is done with Qlik. It's so easy; you just create a measure that returns multiple values and get the aggregation level that you need. You don't need to "pre-cook" all the data.
I guess there are other scenarios where PowerBI is easier than Qlik. Many thanks for your help and your time. Really appreciated.
AlexisOlson
Super User
Super UserThe difficulty here is that you are essentially wanting to treat the list of versions as both a dynamic measure and a dimension at the same time. This is a pretty unusual situation.