Dax : % of row total

[Chandrashekar]

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

[Anonymous · Accepted solution]

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.

[Chandrashekar]

Hello,

Thank you & will try this.

Regards,

Chandrashekar B

[amitchandak]

@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]) ))

[Chandrashekar]

Hello Amit,

Ach is not a measure it is direct value.

Regards,

Chandrashekar B