Skip to Content
0
Sep 01, 2023 at 11:30 AM

Can I exclude some members of measures while writing account dimension formula in new model?

44 Views

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.