Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have a master dimension in my app and I want to ignore possible selections in this master dimension for a measure with Set Analysis. It is not valid to use 'Dimension_name=' in Set Analysis as this is a master dimension. Is there any way to achieve this?
Thank you in advance
@jc17 if I understood correctly
to ignore selection add 1 to your set analysis like sum({1<...> MEASURE)
Thank you for your help. If I use what you say, filters in other fields will not be taken into account, and I only need to ignore filters in this master dimension
Hi @jc17 ,
What's the field name linked to the master dimension?
The name is 'Week'
What about the below expression:
sum( {< Week= > MEASURE )
?
It doesn't work, I have the same issue.