Measure to calculate percentage

[melvinkishore]

I have a column with digits from 0 - 9, and I want a measure to calculate the percentage for of the count of each of the digits 0 - 9 relative to the total count of digits in the column.

[v-yuta-msft]

Hi melvinkishore,

'I want a measure to calculate the percentage for of the count of each of the digits 0 - 9 relative to the total count of digits in the column.'

<--- Could you share some sample data and clarify more details about your logic and expected result?

Regards,

Jimmy Tao

[melvinkishore]

Hi Jimmy Tao,

I have shared the data and the solution. I can get the solution easily on a pivot table but need help with DAX.

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure.  Format it as a %

=COUNT(Data[First Digit])/CALCULATE(COUNT(Data[First Digit]),ALL(Data[First Digit]))

Hope this helps.

[melvinkishore]

I got this error message 

[Ashish_Mathur]

You are missing 2 closing brackets, one before / and another before ,.  Look at my formula carefully.

[melvinkishore]

Thank You Anish, I managed to get the output I wanted.

Much appreciated, Melvin

[Ashish_Mathur]

You are welcome.