How to add a column/measure to calculate Average in Matrix (or Table)?

[JustinDoh1]

I am sharing my Pbix file here.

(This is same question that I posted to the "Desktop" yesterday, but I have not gotten any feedback, so I decide to ask in "DAX Commands and Tips".)

I am trying to add a Column here in Matrix that calculates Average of all numbers listed throughout dates:

So, example, it would be (21+21+19+19..+20) / 8 = average for "VA".

Currenly, I only have Total (that comes matrxi as Column subtotals).

This is illustration of Rows, Columns and Values from Pbix file:

What is formula for column? Do I have to use measure for this?

If Matrix is not possible, should I change to Table visual?

Thanks.

[JustinDoh1]

@vapid128 Thank you so much!

[vapid128]

add measure

DailyClients = AVERAGEX(VALUES([DATE]), CALCULATE([# OF CLINTS]))

[JustinDoh1]

@vapid128 

Sorry for bothering you again.

I am trying to understand how measure works in PowerBI.

I know this (bottom image) is where it addes column subtotal.

But, what caused this to not display "subtotal", but display "average"?

If I put Column subtotals as "off", no "average" shows up, so I am wondering how does Average tie to "subtotals".

Thanks.

[JustinDoh1]

@vapid128 Thank you so much.

How do you put the measure at the end only?

Mine looks like this (repeating):

I was not able to put inside Column directly..

Thanks.

[vapid128]

remove the (# of Clients) in values

[JustinDoh1]

@vapid128 

Thank you so much!

Sorry. one more thing..

Is there way to format number to display with no decimal for each day's value but with one decimal for the average (illustrated as below)?

[vapid128 · Accepted solution]

[JustinDoh1]

@vapid128  

I am tryng to understand the logic of this measure (decimalFix) here.

How does the "Average" not be considered as 

DISTINCTCOUNT(DimDate1[DateFormat])<>1 ?

Thanks.