topic get the percentage of a value out of the column in DAX Commands and Tips

get the percentage of a value out of the column

Anonymous — Mon, 12 Sep 2022 08:10:38 GMT

hello,

i have a matrix with several groups, and i have a measure that calculates for each row the average of the last 6 months.

now i am looking for a way to get for each row the percentage of it out of its group.

for example the first row's percentage should be 23.9% >> 151049/SUM(all other values)

thank you very much for your help.

Re: get the percentage of a value out of the column

johnt75 — Mon, 12 Sep 2022 14:35:09 GMT

You can use

sub cat % = VAR currentValue = [NNS Avg 6 Months] VAR totalValue = CALCULATE ( [NNS Avg 6 Months], ALLSELECTED ( 'Table'[Sub-category] ) ) RETURN DIVIDE ( currentValue, totalValue )

Re: get the percentage of a value out of the column

Anonymous — Tue, 13 Sep 2022 02:17:19 GMT

Hi Anonymous ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Measure = IF( ISINSCOPE('Table'[Group]) && NOT(ISINSCOPE('Table'[Group1])), DIVIDE( [NNS Avg 6 Months], SUMX( FILTER(ALLSELECTED('Table'), 'Table'[Sub-Category]=MAX('Table'[Sub-Category])),[Amount])) ,[NNS Avg 6 Months])

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly