Forum Discussion
Create a filtered average column by combining two measures
I am new to Power BI and I want to create a new column that an average of the total of two other columns. I can create the total using a measure: TOTAL 1 = DISTINCTCOUNT(Database[Column 1]) ...
You will need a measure then, like this:
Measure = DIVIDE(SUM(Database[Column 2]), DISTINCTCOUNT(Database[Column 1]),0)
Measure = DIVIDE(SUM(Database[Column 2]), DISTINCTCOUNT(Database[Column 1]),0)
Okay got it. My final step is take the average measure (.59) and make that number repeat in its own column.
Ex.
.88 .59
.47 .59
.24 .59
Etc.
My goal is to create a dual axis chart with bars of different heights for each value, and a consistent line across the entire chart - I can create this chart on my own.