Filter Story and Defect Issue Type without Aggregate

How To filter Issue Type(Dimension) so that two particular issue type are included as single column without aggregate.

How to do it?

I already have it
Aggregate({
[Issue Type].[Story],
[Issue Type].[Defect]
})

I don’t want it.

Hi,

you still would need a calculated member to display two members into one column.
Instead of Aggregate(), you may use a sum of those members in the calculation formula:

[Issue Type].[Story]+[Issue Type].[Defect]

Then this calculated member won’t be expandable.

Ilze (support@eazybi.com)

1 Like