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.