Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Dear All,
I am working on identifying outliers in the given data having 30+ Measures (these measures cannot be altered as it is coming from the source). I have done some calculations for 3 of the measures and generated a report based on that. But I need to implement the same formula (just the Measure alone will change) for all the other Measures.
Can this be done using Calculation Group or any other thing?
Please help me achieve this as implementing this for 'N' number of Measures is a tedious job. It would be great if there is a way where dynamically the formula could be applied for all any Measures that come in the future as well...
Sample report screenshot is shown below... Each column represents a separate Measure.
Thank you so much in advance.
you want to create the same logic to multiple measures
calculation is often used to create different logic for same measure .
however using tabular editor to create the required measure is faster than creating them in power bi .
since you can copy paste the measure multiple times very quickly .
you can select the measure after writing its code, then ctrl + c , ctrl + v ,
you will create all these mesaures.
now you only need the enter each measure and change the columns to reflect the needed column .
finally, dont forget to click on apply changes
If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that thumbs up button ๐ซก๐
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save โฌ200 with code FABCMTY200.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 29 | |
| 27 | |
| 26 | |
| 24 | |
| 16 |
| User | Count |
|---|---|
| 53 | |
| 47 | |
| 38 | |
| 30 | |
| 21 |