![]() The Metric Calculation Group is used where I can put all the metrics that I want users to be able to use to dynamically change what they are viewing.įor example, I want to users to be able to change measures between Sales and Margin using a Slicer from a table.īelow shows how to do this with multiple measures Measures: Sales = SUM ( 'Order' ) Orders = COUNTROWS ( 'Order' ) Avg Order Size = DIVIDE (, ) Unit Cost = SUM ( 'Order' ) Margin = DIVIDE (, Creating Metric Calculation Group ![]() I have created the following measures, which will be used in the steps below to create the Calculation Group In my working example I am using data from the sample database Worldwide Importers. NOTE: All the steps below use Tabular Editor Unlike in the past where I had to use the FORMAT expression which caused the measure to be a STRING. ![]() What this means is that when the measure is displayed it will be correctly formatted. Not only that it also allows me to format the strings of each of the measures separately. Here are the steps below to implement a calculation group where it allows a user to dynamically switch between the metrics. Not only that but listening to webinars by Daniel Otykier and Christian Wade they both mentioned that calculation groups will be coming to Power BI Desktop in a future release. What this means is that it is available in Power BI Pro & Premium, Azure Analysis Services and SQL Server Analysis Services 2019. This is what I will do in my blog post below.Īs it stands today 29 April 2020 you can currently use calculation groups where the Analysis Services compatibility level is higher than 1470. What I did find is that currently there is not step by step process on how to get this working. I have been reading some great blog posts from SQLBI.COM on using and implementing Calculation Groups.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |