Passing Affects Version in a CASE switch

Questions & Answers
1

I am trying to build a report that will count all the issues that have been marked “UAT_Complete” in a specific version. The following is the query I am using:
CASE
WHEN Format [Measures].[Issue affects versions].Value = 2023.06.3.0
THEN
([Measures].[Issues closed], [Label].[UAT_Complete])
END

It is getting formatting issues, can someone please advise what am I missing ?

2

Hi @ankitraj

Try using this formula for your calculated measure:

(
  [Affects Version.By name].[2023.06.3.0],
  [Measures].[Issues closed],
  [Label].[UAT_Complete]
)

That should count closed issues with specific label in the affects versions by name 2023.06.3.0

Martins / eazyBI