Hide a null dimension but keep associated calculated measure.

[Purushothaman]

Hi Experts,

I wanted to Hide a null dimension but keep associated calculated measure. How to achieve this?

Anyone, Please help!!

Thank you!!

[Bunim · Accepted solution]

if(isnull(dimention),"someText",dimention)

[Or · Accepted solution]

This should be automatic if your measures are written appropriately. For example,

Load * INLINE [
Dim, Measure
A, 100
B, 20
C, 50
];
Concatenate
Load * INLINE [
Measure
30];