Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to have a set analysis that has a different identifier based on what is being selected. For example, take the below grid:
The column [2015-Total] is the same data field as [Last Year] except if for the entire year. This was accomplished with using the identifier 1 instead of $. So, it looks like :Sum({1<Year={'$(=vLastYear)'}>}[SALES]). This causes the filters or selections to be ignored. All of them. This works great for ignoring the select date range and shows me the total for 2015, however I also need the other selection to function, which the do not.. The request is really not to ignore all the selection, but to ignore the Year or Month selections and apply the rest. Is it possible to have the "1" to exclude for two selections and at the same time have the "$" for the other fields like [sales directors].
something like Sum({1<Year={'$(=vLastYear)'}>},{$<Sales Director=>}[SALES])
Or try this to just ignore Date related fields
Sum({$<Year={'$(=vLastYear)'}, Month, MonthYear, Date, Quarter, QuarterYear>}[SALES])
Try like this:
Sum({1<Year={'$(=vLastYear)'}, [Sales Director] = $::[Sales Director]>}[SALES])
Or try this to just ignore Date related fields
Sum({$<Year={'$(=vLastYear)'}, Month, MonthYear, Date, Quarter, QuarterYear>}[SALES])
That did the trick. I just need to make those changes to any field with the "1" identifier and include all of the filters. That's the quick solution!
Sunny, While both of your suggestions worked perfectly, this option is the one I implemented. Thanks for the excellent suggestions.