DAX Formula for Stacked CHart

Hi Ramagopal ,

 

For this you need to use a measure to change the different levels of the scope try the following code:

 

% TVR by Promo =
		VAR CurrentSpotType = SELECTEDVALUE('New_Dash_Board'[Type])
		VAR CurrentSpotMother = SELECTEDVALUE('New_Dash_Board'[Mother])
		VAR CurrentPromo = SELECTEDVALUE('New_Dash_Board'[Promotional])

		VAR Numerator =
		SUM('New_Dash_Board'[sum(tvr)])

		VAR Denominator =
		SWITCH(
			TRUE(),
			ISINSCOPE(New_Dash_Board[Promotional]), CALCULATE(
				SUM('New_Dash_Board'[sum(tvr)]),
				REMOVEFILTERS(New_Dash_Board[Promotional]),
				New_Dash_Board[Type] = CurrentSpotType
			),

			ISINSCOPE(New_Dash_Board[Type]), CALCULATE(
				SUM('New_Dash_Board'[sum(tvr)]),
				REMOVEFILTERS(New_Dash_Board[Type]),
				New_Dash_Board[Mother] = CurrentSpotMother
			),
			ISINSCOPE(New_Dash_Board[Mother]), CALCULATE(
				SUM('New_Dash_Board'[sum(tvr)]),
				REMOVEFILTERS(New_Dash_Board[Mother])
			)
		)


		RETURN
			DIVIDE(
				Numerator,
				Denominator,
				0
			)

 

An easier option is to use a visual calculation that way you only need to write the following code:

TVR % = DIVIDE([Total] ,CALCULATE([Total] ,COLLAPSE(ROWS,1 )))

 

Has you can see result is the same:

 

 

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-visual-calculations-overview