How to filter story points based on issue property

I have a question! i put sprint dimension in rows and Sprint story points committed in measure
now I don’t want to show story points that have this condition

issue provisional= True and transition status in ( To do, In progress)
please help me

Hi, @sepehrp

Welcom to the eazyBI community!

To filter the issues, please use the dimensions “Provisional” and “Transition Status” in the pages. If you want to select more than one value, from the dimension, please use multiple; see the reference picture.

Kindly,
Ilze
support@eazybi.com

@ilze.mezite Thanks for your answer but I want to exclude the result based on this condition
( provisional= True and transition status in ( To do, In progress)) and it can’t be happening by selecting filter on page
let me clarify this for you
provisional hast two measures true or empty
I want to show the result based on this condition
(provisional is empty or (provisional=true and transition status=done))

in other words I want to exclude this condition (issue provisional= True and transition status in ( To do, In progress))

Hi, @sepehrp

Thank you for the additional information. In eazyBI all the empty values are stored as “(none)”.

If the Page filter isn’t an option, then two tuples might be an option.

The formula should look something like this:

([provisional].[(none)],
[Measures].[Sprint Story Points committed])
+
([Measures].[Sprint Story Points committed],
[Transition Status].[Done],
[provisional].[true]
)

Please check the dimensions, Provisional spelling, and the values.

Kindly,
Ilze support@eazybi.com