How can I seperate colums from custom field?

Dear all.

I created a custom field which has 3 values as bellows.

With the custom field, I can create the table as bellows.

EXCEED STILL SUCCES TOTAL
issue count issue count issue count
W19, May 09 2022 8 10 21 39
W20, May 16 2022 10 17 3 30

Because I want to separate colums and create new tables as bellows

EXCEED1 TOTAL
issue count
W19, May 09 2022 8 39
W20, May 16 2022 10 30
STILL1 TOTAL
issue count
W19, May 09 2022 10 39
W20, May 16 2022 17 30
SUCCES1 TOTAL
issue count
W19, May 09 2022 21 39
W20, May 16 2022 3 30

I created user defined measure with the script as bellows, but to fail.

It throws error.

[Measures].[ EXCEED1]

=======

NonZero(
Aggregate(
Filter(
[TTS Resolution Status custom field].[TTS Resolution Status custom field].Members,
[TTS Resolution Status custom field].[TTS Resolution Status custom field].CurrentMember MATCHES “EXCEED”
)
)
)

Could you please correnct my script and provide me correct one?

I don’t have any clue to create user defined measure for TOTAL1.

Please let me know how to create user defined member TOTAL1, too.

Regards.

@deniro61

Create a new calculated measure “Issues count Total” using this formula:

(
[Measures].[Issues count],
[TTS Resolution Status customfield].DefaultMember
)

Then select it next to the “Issue count” measure in the report.
And use it with “TTS Resolution Status custom field” dimension members

Martins / eazyBI