Hi,
Here is the scenario, I'm using New model and I have created a formula for one of the member of account dimension. When I'm pulling a report with multiple measures I see the calculated values on all the measures which I don't want it to happen.
For example,
A = B*C
All the accounts have values on same Measures. So, I don't have to use measurelookup for this calculation.
I have 4 measures in my model, the calculated result of "A" is shown on all the 4 measures which I don't want to happen. The calculated value should only go to one measure instead of all.
Anyone who has faced this similar issue or knows the work around on this. Their comments would be deeply appreciated.
Thanks.