Need help in order to filter out a custom issues type using calculated measure

Questions & Answers
,
1

Hi team,

I need some help regarding the creation of a calculated measure to filter out all issues that belong to a particular custom issue type - For ex: Incident.

What could be the formula?

I figured out this:

NonZero(Count(
Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),
– filters issues currently with particular issue type
[Measures].[Issue type] = “Incident”
)
))

But when I try to drill through the components (under Project), it doesn’t show the right count.

Can you please help me with this?

2

Hi @Supratik_Sarkar ,
welcome to the eazyBI community! :wave:

You can add Issue type dimension in Pages and use it for filtering your report by issue type:

eazyBI_Pages_for_filtering
eazyBI_Pages_for_filtering1696×800 130 KB

Also, you may want to see our training videos - they are short videos where we have demonstrated basic concepts about eazyBI: Training videos - eazyBI

best
Gerda // support@eazyBI.com