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)?
Solved! Go to Solution.
Hi @VV13 ,
You could try ALLEXCEPT() function.
Measure = CALCULATE(AVERAGE('Table'[value]),ALLEXCEPT('Table','Table'[date],'Table'[categories])
Best Regards,
jay
@VV13 , Not very clear
Try like
AVERAGEX(Summarize('Office','Office'[Market],'Office'[Market], "_1",CALCULATE(SUM([Column1]))), [_1])
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
Hi @VV13 ,
You could try ALLEXCEPT() function.
Measure = CALCULATE(AVERAGE('Table'[value]),ALLEXCEPT('Table','Table'[date],'Table'[categories])
Best Regards,
jay
Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
User | Count |
---|---|
368 | |
100 | |
67 | |
57 | |
48 |
User | Count |
---|---|
327 | |
113 | |
87 | |
75 | |
61 |