topic Re: Dax : % of row total in DAX Commands and Tips

Dax : % of row total

Chandrashekar — Thu, 13 Apr 2023 11:02:50 GMT

Hello,

How to write DAX to get % of Row total for below table.

Expected result is % of row total(Ach) & % of row total(Bre)

Pri	Ach	Bre	% of row total(Ach)	% of row total(Bre)	Dax(% of row total(Ach)	Dax(% of row total(Bre)
S1	84	1	98.82%	1.18%
S2	457	2	99.56%	0.44%
S3	975	2	99.80%	0.20%
S4	4		100.00%	0.00%
S5	2		100.00%	0.00%
Total	1522	5	99.67%	0.33%

Regards,

Chandrashekar B

Re: Dax : % of row total

amitchandak — Thu, 13 Apr 2023 14:25:15 GMT

Chandrashekar , Usually we do it like

Assume Ach is measure

% of total =

Divide([Ach], calculate([Ach], allselected()) )

% of row total =

Divide([Ach], calculate([Ach], removefilters(Table[Pri]) ))

Re: Dax : % of row total

Chandrashekar — Fri, 14 Apr 2023 03:44:08 GMT

Hello Amit,

Ach is not a measure it is direct value.

Regards,

Chandrashekar B

Re: Dax : % of row total

Anonymous — Tue, 18 Apr 2023 06:01:02 GMT

Hi Chandrashekar ,

Please try to create measure with below dax formula:

% of row total(Ach) = VAR _ach = SELECTEDVALUE ( 'Table'[Ach] ) VAR _bre = SELECTEDVALUE ( 'Table'[Bre] ) VAR _val = DIVIDE ( _ach, _ach + _bre ) VAR _a = SUMX ( ALL ( 'Table' ), [Ach] ) VAR _b = SUMX ( ALL ( 'Table' ), [Bre] ) VAR _val1 = DIVIDE ( _a, _a + _b ) RETURN IF ( HASONEVALUE ( 'Table'[Pri] ), _val, _val1 )

% of row total(Bre) = VAR _ach = SELECTEDVALUE ( 'Table'[Ach] ) VAR _bre = SELECTEDVALUE ( 'Table'[Bre] ) VAR _val = DIVIDE ( _bre, _ach + _bre ) VAR _a = SUMX ( ALL ( 'Table' ), [Ach] ) VAR _b = SUMX ( ALL ( 'Table' ), [Bre] ) VAR _val1 = DIVIDE ( _b, _a + _b ) RETURN IF ( HASONEVALUE ( 'Table'[Pri] ), _val, _val1 )

Please refer the attaced .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Dax : % of row total

Chandrashekar — Tue, 18 Apr 2023 07:05:10 GMT

Hello,

Thank you & will try this.

Regards,

Chandrashekar B