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)?
Go to Solution.
Hi @VV13 ,
You could try ALLEXCEPT() function.
Measure = CALCULATE(AVERAGE('Table'[value]),ALLEXCEPT('Table','Table'[date],'Table'[categories])
View solution in original post
@VV13 , Not very clear
AVERAGEX(Summarize('Office','Office'[Market],'Office'[Market], "_1",CALCULATE(SUM([Column1]))), [_1])
Proud to be a Super User!
Thanks for the reply, but in the DAX I need to summarize by 2 categories ,
1. By Date2. By MarketI used below Dax. but in my visualtion I add this new measure along with the Date or Office get Error
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021