Home Forums Power Pivot CUBEMEMBER / CUBESET problems

This topic contains 0 replies, has 1 voice, and was last updated by  mfarr76 3 years, 3 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #2750

    mfarr76
    Participant
    • Started: 6
    • Replies: 6
    • Total: 12

    Hello,

    I am entering the world of cube formulas and I am running into a problem that I haven’t seen a solution to.

    I have a dataset that has 20 names in it that can be further split into 3 groups: A,B,and C.  My problem is displaying the names in a single row that belong to one of groups.

    For example, Group A has 5 names in it.  I am currently using Cubmember that has a reference to a cell in the worksheet:

    =CUBEMEMBER(“ThisWorkbookDataModel”,”[TABLE1].[NAMES].&[“&AK10&”]“)

    I am trying to create a scatter plot with this data and I want to be able to use a slicer to change between groups, however this doesn’t work when you have hard references as in the equation above.

    I tried using CUBESET and CUBERANKEDMEMEBER in which that shows all the names without a cell reference but I can’t filter groups when using this approach, its all or nothing.

    Does anyone have any suggestions?

    Thanks,

    Michael

     

     

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.