total of all entries in the table

[Anonymous]

Hello, I think have  quit a simple problem, but i cannot solve it. 

	number of declines	total number of requests	%
decline reason 1	57	500	11%
decline reason 2	32	500	6%
decline reason 3	40	500	8%
other	150	500	30%

For the first column I do count(table[id]) and it disributes correctly between different reasons, for the 2nd column I do the same but chose option "don't summarize" in vizualization tab . Unfortunatelly obviously when I'm trying to divide 1st column/2nd column I'm getting 100%. How should I correctly calculate my columns to get correct answer in the 3rd column? I was trying groupby and summarization, but nothing works..or I'm doing it incorrectly. Please help!Thanks in advance!

[V-lianl-msft]

Hi @Anonymous ,

I tested the data provided by you and found that I can get the desired result correctly. Please try to use the divide function to create rhe measure:

% = DIVIDE(MAX(Sheet4[number of declines]),MAX(Sheet4[total number of requests]))

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

[Anonymous]

@V-lianl-msft  unfortunatelly it's not working.This part MAX(Sheet4[total number of requests]) doesn't give total.

[Anonymous]

Thnak you. But unfortunatelly, it's not working because I use the same field from db in number of declines and total number of declines.