Slicer and Cube Formula Errors

[jlichten]

Hello,

I searched the forums but haven't seen this issue yet...

When using cube formulas that are driven by measures and cubesets driven by formulas, I receive the #N/A error when I deselect from a slicer. This is generated because the cubeset formula for that slicer throws an #N/A...

Has anyone else encountered this issue? Is there a known solution?

Thanks in advance,
Josh

 

[Matt Allington]

Do you actually need a cube set for your slicer? I guess you would if you were trying to return a list of members with cubemember, but if you are just trying to capture the slicer input to use as a member input to a cubevalue, then you just use the slicer name. Sorry if you already know that, just thought I would mention it.

My assumption is a non filtered slicer has no cubeset, hence it returns NA. I suggest you just trap for this error with an IFERROR or similar.

 

[jlichten]

Hi Matt,

Thanks for the quick feedback. I was trying to utilize the cubeset trick outlined in Andrew Todd's article on PPP.

I also tried hardcoding the slicer names into the cubevalue formula but unfortunately I still get an error for deselecting slicers (CTRL +Click).

The strange thing is it only does gives errors when I deselect a specific slicer, not all...

 

[bta20]

Hi @jlichten,

It has been a while, but did you find a solution for your issue.
Some years passed by but i face the same issue as you do.

Thanks, any help welcome

 

[jlichten]

Hi There bta20,

Unfortunately I do not recall if I ever found a solution. The majority of our reporting has shifted to PowerBI so I am very rusty with cube formulas.