Forum Discussion
Solved
ALLEXCEPT not working
I am trying to remove row context of specific columns. I am trying to return a % of total sales relevent to a specific sales channel for each product. In otherwords every product when viewed across e...
Probably something like this:
[Total] = SUM( Data[Dollars] ) [Dol SOT CY] = VAR __totalAcrossMarkets = CALCULATE( [Total], VALUES( Data[Product] ), ALL( Data ) ) VAR __currentTotal = [Total] VAR __result = DIVIDE( __total, __totalAcrossMarkets ) RETURN __resultBest
D
By the way... ALLEXCEPT is a very dangerous function. To know when to use it you have to study it in great depth.
Best
D
Best
D