Calculated measure to show High risks

Hi
image

I am using For total Risks the below measure
([Project].[LT],
[Issue Type].[Risk])

For High Risks, I use the below calculated measures
SUM(
FILTER(
[Issue Type].[Risk],
[Measures].[Issue Risk Criticality] > 35
),
[Measures].[Issue Risk Criticality]
)

I wanted to see risks with Issue Risk Criticality > 35 under High Risks…Though I have high risks in my data, currently I don’t see any data getting displayed under High Risks. can you guys help me to resolve the issue?

Hi @Mary ,

Thanks for posting your question!
I suggest doing the following steps:
Make sure you have imported Risk Criticality field as a dimension.
Define a new calculated member in Risk Criticality dimension with the formula below. For example purposes, let’s assume the calculated member is named “All but none”.

Aggregate( 
	Except( 
	[Risk Criticality].[Risk Criticality].Members, 
	{ 
		[Risk Criticality].[(none)]
	}
  )
)

Once you have done so, please proceed with defining a new calculated measure under the Measures dimension with the formula below:

Aggregate(
  Filter(
    Childrenset([Risk Criticality].[All but none]),
    cast([Risk Criticality].CurrentMember.key as integer) >35
  )
)

You can filter the report by the required Project and Issue Type once you select this new measure in your report.

Best wishes,

Elita from support@eazybi.com

1 Like

Thanks @Elita.Kalane for your support.it perfectly displays High risks.

1 Like