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
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 |
No its not resolved but we can close it as I have posted agian this question with more calrifcation. Thanks
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.
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
User | Count |
---|---|
30 | |
18 | |
15 | |
14 | |
10 |