Total Value vs. Row Count

Questions & Answers
1

Hello - I’ve created a custom measure which is counting issues that meet certain criteria:

SUM(Filter(
– this will filter out issues with Ready for demo = yes
Descendants([Ready for Demo].CurrentMember,[Ready for Demo].[Ready for Demo]),
[Ready for Demo].CurrentMember.Name <> “Yes”),
– this will filter out issues where Dev Completed is empty
SUM(Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
isEmpty([Issue].CurrentMember.get(‘Dev Completed’))),
– this measure in the last SUM works as a fitler and as counter
[Status].[In Progress]))

However, I’m getting the below, with a value being double the row count:

image
image1724×612 18.7 KB

Any ideas why this is happening and how I can investigate where the ‘double counting’ is coming from?

1 Like
2

Deleted all imported data and re-imported fresh and this solved the issue :slight_smile:

3

Hi,

You could also try the following code:

Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
[Measures].[Issue Ready for Demo] <> "Yes" –- this will exclude issues with Ready for demo - yes
AND
Not isEmpty([Issue].CurrentMember.get('Dev Completed')) -- this will filter out issues with empty Dev completed
AND
[Measures].[Issues created]>0
)
)

Martins / eazyBI support