Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
BK_PowerBI
Regular Visitor

Calculation Group / Anything - Similar Calculation for multiple Measures

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.

 

Outliers.png

 

 

1 REPLY 1
Daniel29195
Community Champion
Community Champion

@BK_PowerBI 

 

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 . 

 

Daniel29195_0-1706042305044.png

 

 

you can select the measure after writing its code, then ctrl +  c , ctrl +  v ,  

Daniel29195_1-1706042338161.png

 

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 

Daniel29195_2-1706042399822.png

 

 

 

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 ๐Ÿซก๐Ÿ‘

 

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon โ€“ Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save โ‚ฌ200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors