Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Wrong average calculation

Hi    I created a matrix table for to calculate the average of my data by each category. Below is the montly expense data I have, classified by "abnormal" and "normal" expenses. I think the average...
Need Help
Show and Tell
v-zhenbw-msft's avatar
v-zhenbw-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

We can use the following measure to calculate the total of each row and column. You can refer it.

 

average total = 
IF (
    ISINSCOPE ( 'Table'[Abnormal] ),
    SUMX (
        VALUES ( 'Table'[Year] ),
        CALCULATE ( AVERAGE ( 'Table'[Monthly Total] ) )
    ),
    SUMX (
        VALUES ( 'Table'[Abnormal] ),
        CALCULATE ( AVERAGE ( 'Table'[Monthly Total] ) )
    )
)

 

The result like this,

 

 

If it doesn’t meet your requirement, could you please show us the exact expected result based on the table that we have shared?

BTW, pbix as attached.

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.