topic Re: Percentage of total in DAX Commands and Tips

Percentage of total

Anonymous — Mon, 14 Mar 2022 10:38:12 GMT

Hi guys,

I'm looking for some help with calculating a percentage per group and then the difference between the two. These are 2 matrixes coming from customer satisfaction surveys:

The first one has all the results from 0-10 that clients can give us, with the number of times we got the specific result. The second matrix has the results grouped. 9-10 = Promoter, 7-8 are Passive, 0-6 Detractors. The number of times is just a measure using a count formula. The grouping in the 2nd matrix has been made in the column Net_Promoter_Score in the table FactsB2CRawdata. So the column name is 'FactsB2CRawdata'[Net_promoter_Score(groups)]

I'm now looking to create 2 calculations

- the percentage of "Detractor", "Passive" or "Promoter" vs total

- the outcome of % Promoters - % Detractors

Thanks in advance for your help,

best regards,

Jeroen

Re: Percentage of total

Whitewater100 — Mon, 14 Mar 2022 11:30:14 GMT

Hello:

The general measure for this type of calculation is

Share % = DIVIDE(SUMX(FactsB2CRawdata[Net_promoter_Score(groups)],

SUMX(ALLSELECTED(FactsB2CRawdata), [Net_promoter_Score(groups)]))

Where the factable is the first part and your measure goes with it. You may need to substitute your inital count measure for the first share of total.

I hope this helps!

Re: Percentage of total

v-yanjiang-msft — Fri, 18 Mar 2022 08:03:04 GMT

Hi Anonymous ,

According to your description, I create a sample.

This is my formula of times measure.

Tims = CALCULATE ( COUNT ( FactsB2CRawdata[Net_Promoter_Score] ), FILTER ( 'FactsB2CRawdata', 'FactsB2CRawdata'[Result] = "Yes" ) )

Get the correct result as yours.

Here's my solution.

Create two measures.

Percentage = DIVIDE([Tims],CALCULATE([Tims],ALL(FactsB2CRawdata)))

% Promoters - % Detractors = CALCULATE ( [Percentage], 'FactsB2CRawdata'[Net_Promoter_Score(groups)] = "Promoter" ) - CALCULATE ( [Percentage], 'FactsB2CRawdata'[Net_Promoter_Score(groups)] = "Detractor" )

Put the Percentage in the Values of the matrix, get the correct result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

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