Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
For a customer, our company has been developing a solution based on azure analysis services data model and power bi reports using that data model. The customer is very interested to have self service possibilites but also to make use of all measure numbers for their earlier excel sheets. We have ended up with to many measures and now the customer are complaining about there are too many measures and the solution is too difficult to understand. We can see that. So the first thing is to hide or delete unused measures that are not used in the report. That is a terrible job to do. Perhaps you know about an easier way than doing that manually.
Next, how can we reduce the number of measures? there are many similarities in the measures like this:
I guess here is a potensial gain in reducing the number of measures. Of course I am placing some of the measures in folders and that helps a bit. But I want to reduce the numbers of measures. I have heard about Calculation groups. Perhaps there is something there that can help,
I guess many of you have faced with issue and I am very interested to hear how to reduce the number of measures in your solutions
regards
Geir
Regards
Solved! Go to Solution.
@Anonymous you should check caclulations groups and that is exactly used to achieve this.
I would 💖 Kudos 🙂 if my solution helped. ?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous you should check caclulations groups and that is exactly used to achieve this.
I would 💖 Kudos 🙂 if my solution helped. ?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
95 | |
94 | |
80 | |
71 | |
64 |
User | Count |
---|---|
120 | |
105 | |
99 | |
81 | |
72 |