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
Rgant3
Regular Visitor

Custom Static Measurements for each Variable

I want to be able to have each variable calculate with its own measurement each time it is pulled into the report.

 

For example:

Variable 1: Each time this variable's box is checked and brought into the report, I want it to calculate as a SUM

Variable 2: Each time this variable's box is checked and brought into the report, I want it to calculate as an AVERAGE

 

I want these custom measurements to be tied statically to the variables, so each time i pull the variable into the visualization in a different tab, the same calculation happens.

 

Is this possible? Below are picutres the definitions of calculations being changed.

 

Capture1.PNGCapture2.PNG

1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@Rgant3,

 

As mentioned here, dataset owners have the option to set the default summarization for each field. If you are a dataset owner, change the default summarization in the Modeling tab of Power BI Desktop.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-chuncz-msft
Community Support
Community Support

@Rgant3,

 

As mentioned here, dataset owners have the option to set the default summarization for each field. If you are a dataset owner, change the default summarization in the Modeling tab of Power BI Desktop.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Rgant3
Regular Visitor

I want to be able to permanantly set a measurement type for each variable that I pull into the report visualization. For example,

 

Variable 1: When it's box is checked, I want it to appear in the report as a SUM measurement

Variable 2: When it's box is checked, I want it to appear in the report as an AVERAGE measurement.

 

I want these variations to be tied to each variable, so that each time I pull the data into a new tab, the same measurement is taken.

 

Is there a way to acheive this?

Helpful resources

Announcements
60 days of Data Days Carousel

Data Days 2026

Join Fabric 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.