BlackRabbit (10/11/2016)

---

The user used PowerBI to build and view reports, but the file size limitation became a problem, now they want an alternative solution that will give them the same...

PB_BI (10/10/2016)

---

Okay, so reading between the lines here I think what you are trying to do is create a calculation on the cube itself that dynamically displays the percentage of...

OK cool, things are starting to move in the right direction 🙂

I have 2 hierarchies in the cube related to the store:

1. Division

- Division ID

...

If I remove .LEVEL it does not give an error, but I get the same results as before. Where the slicer has no effect.

WITH

...

Thank you for the fast reply!

I tried what you suggested, the Axis show right but the values show #Error.

Error:

The Is function expects a level expression for the 2 argument....