How to compare Row Total with column's Grand Total

[jamuka]

Hello,

I'd like to calculate Total of Category1 / Total of Total (e.g 1.570.673/4.272.815).

I tried 

Distrubition = DIVIDE(Listing[Total];[Total(Stock_Amount)])

but it shows %100 for all rows. Also I tried to get percentage of each columns Total (e.g 16.500/4.272.815) but couldn't find the answer too.

kind regards

[Anonymous]

-- First of all, [Total] must be the main measure.
-- Then, Distribution can be calculated as:

[Distribution] =
-- Category must be the one that you put
-- on the visual to break down calculations
-- by.
var __visibleCategories = ALLSELECTED( T[Category] )
var __totalAcrossVisibleCategories =
	CALCULATE(
		[Total],
		__visibleCategories
	)
var __totalForThisCategory = [Total]
var __distribution = 
	DIVIDE(
		__totalForThisCategory,
		__totalAcrossVisibleCategories
	)
return
	__distribution
	
-- WARNING:
-- Do not ever use this measure in model
-- measures that iterate over a table. If
-- you do, you'll be sorry rather sooner
-- than later. This measure is safe only
-- when used in visuals.

Best

Darek