Forum Discussion
How not to show values for sub items
I have a matrix looks like the below
Is there a way I can only showing the Project A, Project B, Projecct C, Project D, etc. on the
GROUP MS row?
Currently it's a value in the column.
5 Replies
You can modify the dax to look for HASONEVALUE([Project Field Name]) - which will return yes in the lower heirarchy, and no in the group MS row.
e.g. IF(HASONEVALUE([Project Field Name]), BLANK(), [Your Project Measure or Value])
Thanks Vicky. I think this is what i want to use. Two issues
1) For the variable [Your Project Measure or Value] -> i can't actually put in any column value (it can only be measure, like min or maxing something)
2) Once I added this value into the Values of the matrix. I lose all the child rows, i.e., after i expand the MS group, there are nothing in side.
Thanks!
1) you will then need to sumamrize, or use SELECTEDVALUE([ColumnName]) if there's only 1 value per row
2) i'm a bit confused - didn't you just want the values in the upper-level of the groups? you can replace BLANK() with whatever you want to see in the children rows.
Anonymous , You have to use that in the row as the first value.
Or use as second Value and expand
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
