Forum Discussion
Calculated Groups and Dynamic Measure Selection
Hi,
I have a PBIX file that currently has almost 700 measures. A lot of these are duplications of the same set up for things like FYTD, PFYTD, Rolling 12 Months, etc. These time intelligence measures have the same set up, regardless of the measure they're pointed to.
I've looked at calculated groups as a way to reduce this down. However I want to know if there's a way to use this a bit more dynamically. For example, let's say I have the following measures calculated monthly - I make measures for these rather than adding the field directly to a visual:
- Digital Leads
- Total Active Clients
- Service Responsiveness
In a matrix layout, I would like to show the following:
- Digital Leads
- Digital Leads FYTD
- Total Active Clients
- Service Responsiveness Rolling 12 Months
There may be a need for me to have Digital Leads PFYTD added a some point, so I would want to have this ready to go in case it needs to be swapped out.
How can I use Calculation Groups dynamically to help me achieve this? If Calculation Groups is not the best way, is there another where I can set up a reference calculation for others to use, which will reduce down the number of measures I have and hopefully improve performance?
Thanks,
Mark
5 Replies
- parry2k
Super User
Anonymous Calculation groups is the way to go and what you have mentioned is what calculation groups get used for. I have tons of videos on my YT channel which talks about various uses cases of calculation groups, and specially more about what kind of things one should take care of when using calculation groups. I would highly recommend to review this playlist and make use of it. Here is the link to the playlist: https://www.youtube.com/playlist?list=PLiYSIjh4cEx2s8-jXBhv5aCu5_6F9zQ3I
BTW, Calculation groups are one of my favourite topic when it comes to Power BI, hence so many videos 🙂
Here's an example of what I mean parry2k :
In this example, I have multiple measures added to this matrix. You'll see Digital Leads as a monthly value from the original measure, then Digital Leads for FYTD. Then at the bottom of the screen we have Service Responsiveness as a rolling 12 months. So the value in the month column is specific to each measure.
How can I do this?
