Power BI DAX - Average Per Category Calculation

[Anonymous]

I have a requirment to average by 2 Categories i.e. By Date (Year/Quarter/Month) and by Market. How could I get in DAX average by tow categories?. 

Using Quick Measure I get this , how to add another category  - By Date (Year/Quarter/Month)?

AVERAGEX(

    KEEPFILTERS(VALUES('Office'[Market])),

    CALCULATE(SUM([Column1]))

)

[amitchandak]

@Anonymous , Not very clear

Try like

AVERAGEX(Summarize('Office','Office'[Market],'Office'[Market], "_1",CALCULATE(SUM([Column1]))), [_1])

[Anonymous]

Thanks for the reply, but in the DAX I need to summarize by 2 categories , 

1. By Date
2. By Market

I used below Dax. but in my visualtion I add this new measure along with the Date or  Office get Error

AVERAGEX(SUMMARIZECOLUMNS(Date[Calendar Month],Offices[Name],"Name1", SUM(Column1[]), [Name2])

[Anonymous · Accepted solution]

Hi @Anonymous ,

You could try ALLEXCEPT() function.

Measure = CALCULATE(AVERAGE('Table'[value]),ALLEXCEPT('Table','Table'[date],'Table'[categories])

Best Regards,

jay