Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 ...
Need Help
vicky_'s avatar
vicky_
Icon for Super User rankSuper User
2 years ago

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])

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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!

  • vicky_'s avatar
    vicky_
    Icon for Super User rankSuper User
    2 years ago

    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.