Community: I'm very new to Power BI. I'm struggling with one issue. My dashboard works just fine except for one issue. How do I change the Total Column to calculate a simple average vs. a weighted average? The column values are all averages. I use the slicers to select multiple attributes that populate the columns. I have multiple slicers i want to use. The Total is giving a weighted average (just what its suppose to do!) What I need is a simple average. For the first row, I want this: (ROW SUM)/COUNT OF COLUMNS) (60.0 + 66.7)2 = 63.35. The weighted average = 60.6 because I have more C GENETIC COLOR data than D LEAF SPOT DATA. Data = # of Trials. Any thoughts on how I can solve this? I want to be able to select with the slicers any number of attributes and Years and have a simple average total column.
Thoughts on how to do this? Really appreciate the help.
@12489 wrote:
Community: I'm very new to Power BI. I'm struggling with one issue. My dashboard works just fine except for one issue. How do I change the Total Column to calculate a simple average vs. a weighted average? The column values are all averages. I use the slicers to select multiple attributes that populate the columns. I have multiple slicers i want to use. The Total is giving a weighted average (just what its suppose to do!) What I need is a simple average. For the first row, I want this: (ROW SUM)/COUNT OF COLUMNS) (60.0 + 66.7)2 = 63.35. The weighted average = 60.6 because I have more C GENETIC COLOR data than D LEAF SPOT DATA. Data = # of Trials. Any thoughts on how I can solve this? I want to be able to select with the slicers any number of attributes and Years and have a simple average total column.
Thoughts on how to do this? Really appreciate the help.
Do you know measure? I think you can create another measure like below. If it won't work, could you upload your sample pbix file?
average total = (AVERAGE([C GENETIC COLOR])+AVARAGE([D LEAF SPOT]))/2
@12489 wrote:
Community: I'm very new to Power BI. I'm struggling with one issue. My dashboard works just fine except for one issue. How do I change the Total Column to calculate a simple average vs. a weighted average? The column values are all averages. I use the slicers to select multiple attributes that populate the columns. I have multiple slicers i want to use. The Total is giving a weighted average (just what its suppose to do!) What I need is a simple average. For the first row, I want this: (ROW SUM)/COUNT OF COLUMNS) (60.0 + 66.7)2 = 63.35. The weighted average = 60.6 because I have more C GENETIC COLOR data than D LEAF SPOT DATA. Data = # of Trials. Any thoughts on how I can solve this? I want to be able to select with the slicers any number of attributes and Years and have a simple average total column.
Thoughts on how to do this? Really appreciate the help.
Do you know measure? I think you can create another measure like below. If it won't work, could you upload your sample pbix file?
average total = (AVERAGE([C GENETIC COLOR])+AVARAGE([D LEAF SPOT]))/2
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
We want your feedback!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
