Data Model Pivot Table Average Subtotals

[RodoFliess]

Hello Everyone, I´m having an issue witha a pivot table from the data model.

I want the quarterly subtotals to show monthly average rather than sum, but the option is grayed out:

Is there a way i can work around this?

Thank you!

[#2]

@RodoFliess 

If you are on data model I'd recommend not to use implicit measures at all. Create your own DAX explicit measures with SUM, AVERAGE, whatever and use them in PivotTable.

[#3]

@Sergei Baklan 
Thanks for your reply!
I´m not very good with DAX measures, how could I create a measure that sums by month and then shows quarter monthly average?

Thanks!

[#4]

If you post a very small, copiable dataset together with expected results I can show you the necessary measures.

Regards

[#5 · Accepted solution]

@RodoFliess 

For such sample

measure could be

Total:=IF (
    HASONEVALUE ( tbl[Date (Month)] ),
    SUM ( tbl[Value] ),
    AVERAGEX (
        VALUES ( tbl[Date (Month)] ),
        DIVIDE ( SUM ( tbl[Value] ), COUNTROWS ( VALUES ( tbl[Date (Month)] ) ), 0 )
    )
)

[#6]

Thank you so much! This is exactly what I needed!

[#7]

The code Sergei posted solved my problem already, but thank you very much for your offer!

[#8]

@RodoFliess 

You are welcome, glad to help