Help power pivot to exclude a value

Question

I use power pivot and I created a measure for total sales To calculate the sales on each seller I use this measure with reference to a cube member and can't find problems. I wonder if it is possible use member.cubo for find sales for all sellers, except the seller, for example, tony? I hope I was clear thanks to those who will have the patience to help me

sergeibaklan · Answer

Pissi2019&nbsp;
For such sample model

we may use
=CUBEVALUE(
      "ThisWorkbookDataModel",
      "[Measures].[Sales]",
       CUBESET("ThisWorkbookDataModel",
            "EXCEPT(
            [tblSales].[Seller].[All].children,
            [tblSales].[Seller].[Tony] )"
      )
)

pissi2019 · Answer

SergeiBaklan&nbsp;&nbsp;thanks for your help if I have not misunderstood, there is the possibility to simply write a cube member with negative value -tony to have the same result? I misunderstood ?

sergeibaklan · Answer

Pissi2019&nbsp;
I'm not sure, didn't use such tuple. Here logic is straightforward - you get measure value from the set of all members except something.

Forum Discussion

Help power pivot to exclude a value

3 Replies

Resources