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?
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”.