Forum Discussion

TatianaGuihur's avatar
TatianaGuihur
Helper I
4 years ago

Count in Matrix

Hi all,

 

I am doing a measure to show in a matrix. What I need to do is to count how many POURC the people has. If they have only one 100 so I show it in the line. However if the people has one 100 plus another values exemple,POURC( 83.33,16.67,100) I only shoud show the POURC different to 100.

 

Can you help me please, see the image.

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    TatianaGuihur remember that in a matrix visual each measure gets calculated four times,  Use HASONEVALUE and ISINSCOPE to influence the computation .