Getting the value of 2nd related slicer to put in formula RRS feed

  • Question

  • I have a data model with a project table that consists of a Project_Code and a Project_Name.

    the ProJect_Code is used as a slicer and I can get the Project code into a cell by using "'=CUBERANKEDMEMBER("ThisWorkbookDataModel",Slicer_Proj, 1)".

    I also want to get the name of the project so that I can use that in a header for the report, but I can't get it out.  

    I have added another slicer with the Project_name and use a similar formula to above, but it always returns with "ALL". 

    When you click on the Project_Code slicer, one code is highlighted and the rest are not highlighted (white).  In the Porject_Name slicer, the relevant name is highlighted but all the other names in the slicer are half highlighted.

    How can I get the name of the Project Name to use in a normal excel formula?

    Regards, Sergei

    Friday, October 26, 2018 6:33 AM