Show the values on row headers only

[Anonymous]

Hi Experts,

I need help, I need to show the total value only on row headers only.

Please help me to create a measure for that. 

For example the total value is 100 then it should show only on Charges and recoveries.

Please help, its urgent.

Regards.,

Swamy

[Anonymous]

perfect !!!!

[danextian]

Hi @Anonymous ,

With just the data given, you can create a measure similar to below

My Measure =
IF ( NOT ( HASONEVALUE ( Table[Column] ) ), [Other Measure] )

Table[Column] refers to the column used after Charges and Recoveries (6925, ALLOCA_CNR, etc.).

[Anonymous]

Hi,

I want to show total value of rows in row header and row's values should be 0.

as shown below.

[danextian · Accepted solution]

You can add another argument to the formula I previously posted.

Formula =
IF ( NOT ( HASONEVALUE ( Table[Column] ) ), [Other Measure], 0 )

If the result isn't what you expect, please post  a sample data anyone can simply copy paste - not an image.  How to Get Your Question Answered Quickly