ALLEXCEPT not working

Question

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 each channel would total 100%. To do this I am creating a VAR totalSales which should calculate total sales for each product across total market. However my current result is giving me a % of total sales for all products and all markets.&nbsp;I would really appreciate anyone who can try and help point me in the right direction as I have not been able to solve this for the last few days!&nbsp;&nbsp;Channel AChannel BBrand A65%35%Product A50%50%Product B40%60%Product C70%30%&nbsp;&nbsp;Dol SOT CY = 
VAR totalSales = 
    calculate(
        SUM(Data[Dollars]),
        ALLEXCEPT(Data,Data[Product])
        )
           
Var sales = SUM(Data[Dollars])
   
 Return
    sales/totalSales&nbsp;&nbsp;

anonymous · Accepted Answer

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
	__result
&nbsp;
Best
D

Forum Discussion

ALLEXCEPT not working

2 Replies

Related content

Allexcept

Filtering with ALLEXCEPT()

ALLEXCEPT DAX function not working

Allexcept not working

Filter and Allexcept

	Channel A	Channel B
Brand A	65%	35%
Product A	50%	50%
Product B	40%	60%
Product C	70%	30%