TOTAL COLUMN: NEED SIMPLE AVERAGE

[12489]

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.

[Eric_Zhang · Accepted solution]

---

@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.

---

@12489

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]

Let me try that.  Appreciate the help...