Forum Discussion

Pissi2019's avatar
Pissi2019
Copper Contributor
May 03, 2022

Help power pivot to exclude a value

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 ...
excel
training
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 03, 2022

Pissi2019 

For such sample model

we may use

=CUBEVALUE(
      "ThisWorkbookDataModel",
      "[Measures].[Sales]",
       CUBESET("ThisWorkbookDataModel",
            "EXCEPT(
            [tblSales].[Seller].[All].children,
            [tblSales].[Seller].[Tony] )"
      )
)
Pissi2019's avatar
Pissi2019
Copper Contributor
May 04, 2022

SergeiBaklan 

 

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's avatar
    SergeiBaklan
    Diamond Contributor
    May 05, 2022

    Pissi2019 

    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.

Resources