Forum Discussion

awashington6's avatar
awashington6
Regular Visitor
4 years ago

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...
average
Average Averages
Average Rates
New Table
ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
4 years ago

Hi,

I think the likely reason behind this is that you have some filter affecting the calculation (in your test) or alternatively "However, when I create the table for with "Usage Rate" by district for that specific year, the table reads 83.5. "

Here you refer to year but in your original DAX you use fiscal year. I recommend double cheking filters + columns used since the DAX seems good on a glance. To elaborate further I would need to see the data. (as littemojopuppy mentioned)