Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
aishaakhter18
Helper I
Helper I

Need to help in calculating percentage

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. 

 

aishaakhter18_0-1694044612179.png

 

TAPRRA
1ABC 
2DEF 
3GHIYes
4LMNYes
2PQR 
3ABCUnder Assessment
4DEFYes
6GHIUnder Assessment
5LMNUnder Assessment
6PQRUnder Assessment
5ABCUnder Assessment
1DEFYes
2GHIPlanned
3LMNYes
1PQRYes
2RXTUnder Assessment
3SARUnder Assessment
4SADUnder Assessment
2MADUnder Assessment
3DEFPlanned
4GHIPlanned
6LMNUnder Assessment
5PQRUnder Assessment
6RXTUnder Assessment
5SARUnder Assessment
1SADUnder Assessment
2MADUnder Assessment
3ABCUnder Assessment
1DEFPlanned
2GHIUnder Assessment
3LMNPlanned
4PQRPlanned
2ABCPlanned
3RXT 
4SARYes
6SADYes
5MADYes
6ABCYes
5DEFUnder Assessment
1SADPlanned
2MADPlanned
3ABCPlanned
I&IDEFYes
Rare Blood DisordersGHI 
OncologyLMNYes

 

3 REPLIES 3
aishaakhter18
Helper I
Helper I

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

v-tangjie-msft
Community Support
Community Support

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. 

DataNinja777
Super User
Super User

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%. 

 

 

Sakiko_0-1694053189760.png

 

Sakiko_1-1694053309223.png

 

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.  

 

Sakiko_3-1694055125252.png

I attach the pbix file in the link below:

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

 

 

Helpful resources

Announcements
October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors