You can change you table like this:
Then create a measure
Measure = AVERAGE('Table'[Daily Average])
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for the response. It won't work since 'Daily Average' is a measure.
This is what I got:
Two ways I calculated. still did not correct answer
Thank you so much for the solution. Total and days worked are measures . I got an error message like'column table 'total' in query 1 can not be found. Any idea how to resolve it.
i got another error when slightly changed the formula
sum([Total])/sum([Days worked]). The sum function only accepts a column reference as the argumentnumber1
you can plot a table visual with the unit head column and a measure like this:
verified and it worked like this:
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.