Measure - Total and filter

[ChrisB7]

Hi,

I would like to create a measure where I am finding the total for one dimension (or rather ignore another), but also to provide a filter. 

e.g. SUM( TOTAL <Dim1>, {$<IsCurrent={'1'}>}, Value) 

I am not sure if this is possible, or my syntax is just wrong, but help would be appreciated.

Thanks,
Chris

[kaushiknsolanki · Accepted solution]

Hi Chris,

You are almost there.

Just removed commas.

SUM( TOTAL <Dim1> {$<IsCurrent={'1'}>} Value) 

Regards,

Kaushik Solanki

[ChrisB7]

Thanks Kaushik.

I believe, I also found a similar way to do it like the following.

SUM( {$<IsCurrent={'1'}, Dim1 =>} Value)

So setting the Dim1 = no restriction

Thanks again,
Chris