Is it possible to at all to access the measures in the same worksheet where we have already filtered them? I tried doing it with the Include function, however couldn't succeed.
Hi Nicholas, there is probably a hack-y workaround but ideally for this to work you need to re-shape your data, something along these lines:
Order Date Market Category Net Sales Current month Sales Prior month sales Category of Sales Categorical or Non-categorical
Thanks for your reply.
Unfortunately the Architecture can't be changed, however I have created the calculated fields as all of these.
Any other work around?