Forum Discussion
Average of Rates
I built out a table in powerBI to give me average of a series or rates. However, the average is wrong. I wrote out the new table like this: summarizecolumns(Sheet1[District],'Sheet1'[Fiscal Year...
I am still very new to this. I think I may have done this incorrect or described the situation incorrectly. I think I see what the problem is but do not know how to fix. I created a summarized table for totals by year. I then create another summarized table, create a matrix on the same page. It appears that the first matrix is threwing off the second matrix. In looking at the relationship, there is no relation between the two tables. However, they both are connected to same lookup table in relationshops. Any guidance would be helpful.