Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI QV Experts,
I have a month dimension in my data and a chart in which i use the same month dimension.
I have a requirement where regardless of the month i select, the chart should not change. HOwever, i have other filters to which the chart should change accordingly except this month dimension.
I need to acheive this without having to use set analysis or alternate state.
Thanks
I see three solutions:
1. Set analysis (you don't want it)
2. disconnect object (you will loose all connections with all the dimensions fields)
3. create a disconnected table like attached below
Why you can't use Set Analysis ?
With Set Analysis an Expression like this : =sum({<Month>}[Sales units]) will work perfectly.