Forum Discussion
Any One Can do This ?
Hi Jalil239
You should be able to use ISINSCOPE for this.
Lets say you have a measure called "Average Measure".
You can make a new measure that would look something like this:
New Average = IF( ISINSCOPE( Table[Month]),"",[Average Measure])ISINSCOPE will evaluate true when the months are "in scope", and false for the totals. You can read more about ISINSCOPE here and here.
Hi all,thanks for the quick reply, I'll add more.
Hi Jalil239 ,
You can achieve your needs indirectly.
1.Turn off word wrap
2.Move the mouse to the marked position, and a '<-||->' sign will appear. Drag it to hide it.
Best Regards,
Wenbin Zhou
Hi Jalil239
You should be able to use ISINSCOPE for this.
Lets say you have a measure called "Average Measure".
You can make a new measure that would look something like this:
New Average = IF( ISINSCOPE( Table[Month]),"",[Average Measure])
ISINSCOPE will evaluate true when the months are "in scope", and false for the totals. You can read more about ISINSCOPE here and here.
Its work but it still showing this red area I dont want to show this one
Jalil239 for that, you can use field formatting option and and change the color of taht field to blue, then end user can't see!
Hi all,thanks for the quick reply, I'll add more.
Hi Jalil239 ,
You can achieve your needs indirectly.
1.Turn off word wrap
2.Move the mouse to the marked position, and a '<-||->' sign will appear. Drag it to hide it.
Best Regards,
Wenbin Zhou
