topic Need to help in calculating percentage in DAX Commands and Tips

Need to help in calculating percentage

aishaakhter18 — Thu, 07 Sep 2023 00:02:30 GMT

I like to get a percetage for each PR for each response under RA, as shown is chart below, I tried but the result of persentage is not coming to 100% but more than that , its mean it counting PR double or triple for each respons . How should i correct it and what should be the DAX for this kind of calculation.

TA	PR	RA
1	ABC
2	DEF
3	GHI	Yes
4	LMN	Yes
2	PQR
3	ABC	Under Assessment
4	DEF	Yes
6	GHI	Under Assessment
5	LMN	Under Assessment
6	PQR	Under Assessment
5	ABC	Under Assessment
1	DEF	Yes
2	GHI	Planned
3	LMN	Yes
1	PQR	Yes
2	RXT	Under Assessment
3	SAR	Under Assessment
4	SAD	Under Assessment
2	MAD	Under Assessment
3	DEF	Planned
4	GHI	Planned
6	LMN	Under Assessment
5	PQR	Under Assessment
6	RXT	Under Assessment
5	SAR	Under Assessment
1	SAD	Under Assessment
2	MAD	Under Assessment
3	ABC	Under Assessment
1	DEF	Planned
2	GHI	Under Assessment
3	LMN	Planned
4	PQR	Planned
2	ABC	Planned
3	RXT
4	SAR	Yes
6	SAD	Yes
5	MAD	Yes
6	ABC	Yes
5	DEF	Under Assessment
1	SAD	Planned
2	MAD	Planned
3	ABC	Planned
I&I	DEF	Yes
Rare Blood Disorders	GHI
Oncology	LMN	Yes

Re: Need to help in calculating percentage

DataNinja777 — Thu, 07 Sep 2023 02:58:19 GMT

Hi aishaakhter18

Your PR field contains many duplicates, and also, concatenation of TA and PR also contains many duplicates, and this appears to be the reason why your percentage is not adding up to 100%.

Do you need to treat each row in your table (45 countrows in total) as part of your percentage total? In that case what about adding an index column to treat them separately?

As an example, I've added an index column using Power Query, which provided distinct identifier for 45 rows, and prepared the visualization below.

I attach the pbix file in the link below:

https://1drv.ms/u/s!AlqFfzVTqicpnXgNyEcwA0nruZDt?e=NgJxgM

Re: Need to help in calculating percentage

Anonymous — Mon, 02 Oct 2023 02:44:33 GMT

Hi aishaakhter18 ,

Has your problem been solved? If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out. Thanks in advance.

Best Regards,

Neeko Tang

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

Re: Need to help in calculating percentage

aishaakhter18 — Mon, 02 Oct 2023 02:51:35 GMT

No its not resolved but we can close it as I have posted agian this question with more calrifcation. Thanks