Forum Discussion
Display the quarterly average on a Matrix
Hi brunohelder ,
Can you provide sample data, so that we can better solve the problem for you.
Best regards,
Community Support Team_ Scott Chang
I am not able to attach files... Please find an example
Hi brunohelder ,
I made simple samples and you can check the results below:
AVG Count = var _t = ADDCOLUMNS('Table',"A",COUNTAX(FILTER(ALL('Table'),[Date].[Quarter]=EARLIER([Date].[Quarter])),[ID])) RETURN DIVIDE(AVERAGEX(_t,[A]),3)An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
On my data the average on the months it is not the same as in the sample.
I don't understand why.
I had to change a bit the formula because you where filtering ALL the table and I don't want that.
Average activity per Quarter (IN) =
VAR _t =
ADDCOLUMNS (
Table,
"A",
COUNTAX (
FILTER (
( Table),
Table[ Date [.[Quarter]
= EARLIER ( Table[ Date].[Quarter] )
),
Table[ID]
)
)
RETURN
DIVIDE ( AVERAGEX ( _t, [A] ), 3 )Hi brunohelder ,
Because in my expression I fixed that there are three months in a quarter, even though there is no value.
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.