Filtering based on some conditions

Questions & Answers
1

Hi,

I am trying to filter my data based on the following conditions

  • [Priority] = P1
  • [Priority] = P2
  • [Priority]= Undecided AND [Customer Impact] = ‘Critical’

I have imported the Customer Impact as Dimension and added priority to my “Paging”. I am able to filter P1 and P2 without any issue. So I am tried to add a new Priority Dimension member using Define New Calculated member using the following formula
Aggregate({
Filter([Issue].[Issue].Members,
[Priority].[Undecided]
and [Customer Impact].[Critical]
)
})

but i got the following error
Formula is not valid:
No function matches signature ’ AND ’

I am not sure I did the right thing. Any help would be appreciated. Thank you!

2

Hi @EBI ,
Welcome to the eazyBI community!

Here you could achieve the filtering by creating a new calculated measure with Case statement that would know how to calculate results for the given report page filter selection.

Try this formula:

CASE 
  WHEN
  [Priority].CurrentMember.name = "P1"
  OR
  [Priority].CurrentMember.name = "P2"
  THEN
  Sum((
  [Measures].[Issues created],
  [Customer Impact].DefaultMember
  ))
  ELSE
  Sum([Measures].[Issues created])
END

It will ignore the Customer impact filter when P1 and P2 is selected,

Martins / eazyBI support

image
image1624×838 112 KB