hide measure for one of the conditions

[Anonymous]

So, here I have different "statuses". The "number of work weeks" measure has to be displayed only for the RTBS and not for the others. At the moment, it's being displayed as blank for all the other statuses except RTBS. However, I want to make it so that the measure is displayed only for the "RTBS" and not for others. So, only RTBS should display 3 measures others should only display 2. Is there a way to do this ?

[CoreyP]

You need to create a dim table with the SAP Status and the relevant measures, like so:

( I only typed in 2 for example, but you'll need it for all your statuses )

Create a relationship to your SAP Status column in your fact table. Use the status and measure fields from this table in your matrix visual. Then you'll need to write a measure to do the appropriate calculation depending on the row context of measure. Like so:

[Anonymous]

I did what you suggested me to do but I'm not able to generate what i would like to. Please help 

[CoreyP]

The measure I provided was just an example. You have to actually edit it to return a measure for each condition. Right now, it's just text.

[Anonymous]

what will be the next step after this