Forum Discussion
Force Aggregation to a specified dimension
I am attempting to implement a measure that averages a count over the day of the week for a specified time period. When I used Tableau I was able to accomplish his with Level of Detail calculations...
Hi MichaelWinz ,
I created some data:
Here are the steps you can follow：
1. Create calculated column.
Weekday = WEEKDAY('Table'[Date])2. Create measure.
Measure =
AVERAGEX(FILTER(ALLSELECTED('Table'),'Table'[Weekday]=MAX('Table'[Weekday])),[Value])3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
This doesn't work in my situation. The measure being summed is always 1. What I need is an Average of Sums Across WeedDays.