Forum Discussion
Measure Counting incorrectly based on filter
Hello, I have a table of projects that each get an overall Project Score. This is a measure that adds the results of other measures to calculate the "riskiness" of a project. Based on the score...
Hi Anonymous JarroVGIT
Here is the Measure the computes the overall project score:
M_Overall Project Score =
[M_Sched Perf]+[m_Project Issue Score]+[m_Project Risk Score]
+ [M_Scope Score]
Here are the Measures that are added in the Overall Project Score:
M_Sched Perf =
1.5*(
DIVIDE
(AVERAGE
('Projects'[Project duration]),
AVERAGE('ProjectBaselines'[Project Baseline Duration])
))
================================================
m_Project Issue Score =
MAXX(
KEEPFILTERS(VALUES('Issues'[Project Name])),
CALCULATE(MAX('Issues'[C_Issues Scoring]))
)
================================================
m_Project Risk Score =
MAXX(
KEEPFILTERS(VALUES('Risks'[Project Name])),
CALCULATE(MAX('Risks'[c_Risk Scoring]))
)
================================================
M_Scope Score =
Maxx(KEEPFILTERS(VALUES('BurndownScope'[c_Scope Score])),
CALCULATE(
MAXX('BurndownScope','BurndownScope'[c_Scope Score])
))
Interestingly, per the attached screenshots, the count doesn't change from 13 regardless whether I filter out cancelled and closed projects (as they should be). The Project name comes from the burndownscope table and the Project state filter comes from the "Projects table. The relationship is a 1 to many from Burndownscope to Projects via a field called Clarity ID. It is bi-directional
filtersauto rag table
Hi Clint,
I found you add some visual level filters, current visual level filter effect only works on current visual. (you can't extract filter effect on other visuals) I'd like to suggest you use these fields on slicer to apply filter effect with other visuals.
In addition, you also use lots of times of keepfilters function in your formulas, I'd like to suggest taking a look at the following blog to know more about its effect and usage.
Regards,
Xiaoxin Sheng
Thanks Xiaoxin, I will take a look.