Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Folks, How to achieve Average Sales for each category ? Note: if you have Filters it should affect the visual
@AlexisOlson - Thanks for the prompt response. To give you a big pitcure. I am trying to create year wise average line , even if i apply Region filter average should be calculated after filtering the data.
If you want a flat average line, then you'll need to remove the date filter context.
For example,
CALCULATE (
AVERAGE ( Table1[Sales] ),
ALLSELECTED ( Table1[Year], Table1[Quarter] )
)
There are two approaches:
1. Specify what filters you want to remove (and keep all others) using ALL or ALLSELECTED.
2. Specify what filters you want to keep (and remove all others) using ALLEXCEPT.
It depends on how exactly you want it to work in general (what columns to ignore and what not to), but I'd start with something like this:
CALCULATE (
AVERAGE ( Table1[Sales] ),
ALLSELECTED ( Table1[Sub Category] )
)
This tells it to remove the visual's filter context on Sub Category.
Hi @AlexisOlson , I need to calculate Average line per year, It should accomdate the filters. average line should be calculated on top of filtered data set.
if you aware of super store data set , can you try from your end and let me know the solution.
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
99 | |
88 | |
73 | |
60 | |
58 |