Calculating the impact of one Dimension to the whole

[perezcotai]

I need to show the impact  of each item from Dimension(such as : product/customer ...etc)


This is the kind of calculation that I am looking to do

sum(ALL_Dimension1_numerator])/sum(ALL_Dimension1_denominator])
-
(( sum(ALL_Dimension1_numerator]) - sum(Product_One_Dimension]) ) / ( sum(ALL_Dimension1_denominator]) - sum(Product_One_Dimension) ))

how this can be done ?

[v-jiascu-msft · Accepted solution]

Hi @perezcotai,

Is it the portion of every item in one dimension? Please try the formula below. Please share a dummy sample if you need more support.

Measure 5 =
SUM ( FactSales[SalesQuantity] )
    / CALCULATE ( SUM ( FactSales[SalesQuantity] ), ALL ( DimProduct ) )

Best Regards,

Dale