Forum Discussion
Basic understanding of context, simple example
Hello,
Below is a simple exercise I made in order to try to understand/learn the concept of evaluation context.
The table shows projects, department, month and budgetrevision and budget. BudgetMax is a measure I've created in order to get the latest budgetrevision.
In the clustered column chart I've highlighted the colum for 201807, which then filters the table. However, what I really want BudgetMax to do is show the latest Budget amount (based on revision number), for each project. As you can see, the table shows there are 2 unique project numbers in 201807, and so I want the BudgetMax measure to show 20 000 + 30 000 = 50 000 (both in the table and in the chart).
As you can see from the BudgetMax measure, I'm trying to combine sumx & summarize to solve the problem, without really understanding how they work.
Any help would be greatly appreciated.
TL-DR: Want measure to show latest budget per project, per month
7 Replies
so, when you choose your 201807 in the graph, you're filtering out the three rows 201807. Your filter context (albeit simple as you have only one table) is that, those three rows.
Now if you want to show only a single budgetrevision( as an example) you'll have to put another slicer with the budgetrevision column and when you select "4" your filter context will be the union of 201807 and 4.
If you put a table with MonthKey in columns and Project in rows, each cell of your table will have a specific filter context, made by the union of those values of that column.
So you then create a measure
Budget=SUMX(table;table[budget])
When you put that measure in the VALUES field of your table, it will calculate the values for each cell, considering the filter context of that cell, so in fact showing the data as you want.