Forum Discussion
Matrix visual, don't show rows with empty name
- Anonymous2 years ago
Hi zervino ,
Thanks for the reply from ajohnso2 , please allow me to provide another insight:
According to your description, I created these data.
1. Create a measure to determine whether the three-level names are all empty. If they are all empty, return 999, otherwise return the value to be displayed before.
MEASURE = IF ( MAX ( 'Table'[Team] ) = BLANK () && MAX ( 'Table'[Block] ) = BLANK () && MAX ( 'Table'[Person] ) = BLANK (), 999, SUM ( 'Table'[value] ) )2. Filter the results where the measure is not 999 in the filter, and put the measure into the matrix values position.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi zervino ,
Thanks for the reply from ajohnso2 , please allow me to provide another insight:
According to your description, I created these data.
1. Create a measure to determine whether the three-level names are all empty. If they are all empty, return 999, otherwise return the value to be displayed before.
MEASURE =
IF (
MAX ( 'Table'[Team] ) = BLANK ()
&& MAX ( 'Table'[Block] ) = BLANK ()
&& MAX ( 'Table'[Person] ) = BLANK (),
999,
SUM ( 'Table'[value] )
)
2. Filter the results where the measure is not 999 in the filter, and put the measure into the matrix values position.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.