Count Affected Services

Questions & Answers
, ,
1

Hi,

I have a formula how many Affected Services are empty:

Count(
  Filter(
    [Issue].[Issue].Members,
    IsEmpty([Measures].[Issue Affected services])
  )
)

However, it calculates for the entire data imported and doesn’t reflect the filter of Time (or any filter actually)

image

How can I adjust this ?

thank you

2

Hi @Karim_Momo

Try this formula:


Sum(
Filter(
   Generate(
--set of relevant projects
    Filter(
      [Issue].[Project].Members,
      [Measures].[Issues created]>0
    ),
--set of issues in filtered projects
   DescendantsSet(
    [Issue].CurrentHierarchyMember,
    [Issue].[Issue])
   ),
DateInPeriod(
  [Measures].[Issue created date],
  [Time].CurrentHierarchyMember
)
AND
(
IsEmpty([Measures].[Issue Affected services])
OR
[Measures].[Issue Affected services] <> "(none)"
)
),
CASE WHEN
[Measures].[Issues created]>0
THEN
1
END
)

And please manually select “integer” formatting:
https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-measures#Calculatedmeasures-Formatting

Martins / eazyBI