Forum Discussion
Solved
help needed
present in culum chart Thanks
Hi akas2023 ,
Please try below steps:
1. please add a new tabel
Table2:
2. create measure with below dax formula
B and Above Adj = VAR _class = SELECTEDVALUE ( 'Table 2'[Class] ) VAR _year = SELECTEDVALUE ( 'Table 2'[Year] ) VAR tmp = FILTER ( ALL ( 'Table' ), [Class] = _class && [Year] = _year ) VAR tmp1 = FILTER ( tmp, UNICODE ( [Marks] ) <= UNICODE ( "B" ) ) VAR _val = DIVIDE ( COUNTROWS ( tmp1 ), COUNTROWS ( tmp ) ) VAR tmp2 = FILTER ( ALL ( 'Table' ), [Year] = _year ) VAR _val1 = DIVIDE ( COUNTROWS ( tmp2 ), COUNTROWS ( ALL ( 'Table' ) ) ) VAR _b = IF ( _class = "OverAll", _val1, _val ) RETURN _bC and Above Adj = VAR _class = SELECTEDVALUE ( 'Table 2'[Class] ) VAR _year = SELECTEDVALUE ( 'Table 2'[Year] ) VAR tmp = FILTER ( ALL ( 'Table' ), [Class] = _class && [Year] = _year ) VAR tmp1 = FILTER ( tmp, UNICODE ( [Marks] ) <= UNICODE ( "C" ) ) VAR _val = DIVIDE ( COUNTROWS ( tmp1 ), COUNTROWS ( tmp ) ) VAR tmp2 = FILTER ( ALL ( 'Table' ), [Year] = _year ) VAR _val1 = DIVIDE ( COUNTROWS ( tmp2 ), COUNTROWS ( ALL ( 'Table' ) ) ) VAR _b = IF ( _class = "OverAll", _val1, _val ) RETURN _b3. add a clustered column chart with Table2 fields and measure
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
| Name | Gender | Marks | Year | Class |
| Abdallah Essam Abdelkader Emam Moussa | Male | C | 2019-2020 | Year 1 |
| Abdullah Aref Musieh Mohammed Fadhel | Male | C | 2019-2020 | Year 1 |
| Alreem Omar Buti Salem Alshamsi | Female | A* | 2019-2020 | Year 1 |
| Ameer Mohd Waleed Alshalabi | Male | D | 2019-2020 | Year 1 |
| Carolina Rodrigues Mutti | Female | B | 2019-2020 | Year 1 |
| Fares Mohammad Noman Alsakka | Male | A | 2019-2020 | Year 1 |
| Haadiyah Atif Iftikhar Atif Iftikhar | Female | A* | 2019-2020 | Year 1 |
| Hisham Pedragoza Issa | Male | A* | 2019-2020 | Year 1 |
| Lujain Mohammad Mahmoud Al Azzam | Female | A* | 2019-2020 | Year 1 |
| Abdalla Nasser Abdalla Nasser Alhammadi | Male | A | 2020-2021 | Year 1 |
| Abdoul Rachid Idrissa Adamou | Male | c | 2020-2021 | Year 1 |
| Aisha Abubakar Kullatein Alnadhir | Female | A* | 2020-2021 | Year 1 |
| Azmina Hackeem Hackeem Mohamed Iqbal | Female | B | 2020-2021 | Year 1 |
| Farah Mohammad Faisal Alhelaly Rady Mohammad | Female | A | 2020-2021 | Year 1 |
| Hajara Babagana Zannah | Female | c | 2020-2021 | Year 1 |
| Iyaad Ahmed | Male | A* | 2020-2021 | Year 1 |
| Jeevith Raja Sathish Kumar | Male | A | 2020-2021 | Year 1 |
| Lian Alaa Abuyounes | Female | A* | 2020-2021 | Year 1 |
| Abdalla Nagy Hassan Abdalla Abdelnaeim | Male | A* | 2021-2022 | Year 1 |
| Abdulaziz Mohammed Mahfood Al Zubaidi | Male | C | 2021-2022 | Year 1 |
| Ameer Mohamed Hammad Mohamed Ismail | Male | A* | 2021-2022 | Year 1 |
| AMER MOHAMED AHMED MOHAMED KHALIL | Male | D | 2021-2022 | Year 1 |
| Danna Khaled Ouwer | Female | A* | 2021-2022 | Year 1 |
| Eissa Amr Mohamed Kamel Abdelaziem Mohamed | Male | D | 2021-2022 | Year 1 |
| Hasnath Abdul Ahad Abdul Ahad Mohamed Barak | Female | C | 2021-2022 | Year 1 |
| Majid Ahmed Omer | Male | C | 2021-2022 | Year 1 |
| Raya Mohd Mustafa Abu Ghoush | Female | C | 2021-2022 | Year 1 |
| Mhd Kariem Mhd Bilal Al Khawam | Male | A+ | 2019-2020 | Year 2 |
| Mohamed Ahmed Mahmoud Hamdy | Male | C | 2019-2020 | Year 2 |
| Mohamed Hesham Samir Mohamed Mohamed Said | Male | A+ | 2019-2020 | Year 2 |
| Moustafa Hany Moustafa Abdelhamid Elnahas | Male | A | 2019-2020 | Year 2 |
| Noor Ayman Mahmoud Awad | Female | C | 2019-2020 | Year 2 |
| Qazi Muhammad Saddein | Male | A+ | 2019-2020 | Year 2 |
| Ritag Ahmed Badran Bedir Badran | Female | A | 2019-2020 | Year 2 |
| Rital Ahmed Mahmoud Hamdy | Female | C | 2019-2020 | Year 2 |
| Tamara Alisa Rai | Female | A+ | 2019-2020 | Year 2 |
| Muhammad Ebaad Ahmed Muhammad Furqan Ahmed | Male | A+ | 2020-2021 | Year 2 |
| Nivaan Umesh Talreja | Male | A | 2020-2021 | Year 2 |
| Noah Ephrem Bfkadu | Male | D | 2020-2021 | Year 2 |
| Rihan Zarif Md Saiful Islam | Male | C | 2020-2021 | Year 2 |
| Rim Hany Abdou Ibrahim Abdelfattah | Female | A+ | 2020-2021 | Year 2 |
| Semir Jabr Idris | Male | A+ | 2020-2021 | Year 2 |
| Seyed Amir Seyed Mohammad Hashemi | Male | A | 2020-2021 | Year 2 |
| Syed Zaid Ullah Shah Zubair Ullah Shah | Male | A+ | 2020-2021 | Year 2 |
| Yusra Luai Elnour Abdelmotalib | Female | A+ | 2020-2021 | Year 2 |
| Zafran Juliosqayssar Mohammed Adlan | Female | D | 2021-2022 | Year 2 |
| Abdelrahman Mostafa Mohamed Mohamed Mohamed | Male | A | 2021-2022 | Year 2 |
| Farah Mohammad Faisal Alhelaly Rady Mohammad | Female | A | 2021-2022 | Year 2 |
| Gehad Nedal Nabil Hassan Mohamed Elkilani | Female | A | 2021-2022 | Year 2 |
| Hamza Moataz Mohsen Mohamed Fahmy Abdelsalam | Male | B | 2021-2022 | Year 2 |
| Joudi Ali Ismail | Female | B | 2021-2022 | Year 2 |
| Lian Alaa Abuyounes | Female | A | 2021-2022 | Year 2 |
| Malek Walid Elsayed Emara Ali Emara | Male | C | 2021-2022 | Year 2 |
| Maryam Suror Zerar | Female | A | 2021-2022 | Year 2 |
| B and Above | C and Above | ||
| Year 1 | |||
| 2019-2020 | 82% | 96% | |
| 2020-2021 | 79% | 100% | |
| 2021-2022 | 54% | 95% | |
| Year 2 | |||
| 2019-2020 | 85% | 96% | |
| 2020-2021 | 93% | 98% | |
| 2021-2022 | 68% | 83% | |
| Overall | |||
| 2019-2020 | 79% | 94% | |
| 2020-2021 | 86% | 98% | |
| 2021-2022 | 63% | 87% |
Hi akas2023 ,
Why Year1, 2019-2020, B and above is 82%? why is not 67%? could you please explain the calculate rule?
Best regards,
Community Support Team_Binbin Yu
The percentage is correct but the problem is I cannot include whole table bcoz of characters limitation.kindly help to how to do.thanks
Hi akas2023 ,
Please try below steps:
1. please add a new tabel
Table2:
2. create measure with below dax formula
B and Above Adj = VAR _class = SELECTEDVALUE ( 'Table 2'[Class] ) VAR _year = SELECTEDVALUE ( 'Table 2'[Year] ) VAR tmp = FILTER ( ALL ( 'Table' ), [Class] = _class && [Year] = _year ) VAR tmp1 = FILTER ( tmp, UNICODE ( [Marks] ) <= UNICODE ( "B" ) ) VAR _val = DIVIDE ( COUNTROWS ( tmp1 ), COUNTROWS ( tmp ) ) VAR tmp2 = FILTER ( ALL ( 'Table' ), [Year] = _year ) VAR _val1 = DIVIDE ( COUNTROWS ( tmp2 ), COUNTROWS ( ALL ( 'Table' ) ) ) VAR _b = IF ( _class = "OverAll", _val1, _val ) RETURN _bC and Above Adj = VAR _class = SELECTEDVALUE ( 'Table 2'[Class] ) VAR _year = SELECTEDVALUE ( 'Table 2'[Year] ) VAR tmp = FILTER ( ALL ( 'Table' ), [Class] = _class && [Year] = _year ) VAR tmp1 = FILTER ( tmp, UNICODE ( [Marks] ) <= UNICODE ( "C" ) ) VAR _val = DIVIDE ( COUNTROWS ( tmp1 ), COUNTROWS ( tmp ) ) VAR tmp2 = FILTER ( ALL ( 'Table' ), [Year] = _year ) VAR _val1 = DIVIDE ( COUNTROWS ( tmp2 ), COUNTROWS ( ALL ( 'Table' ) ) ) VAR _b = IF ( _class = "OverAll", _val1, _val ) RETURN _b3. add a clustered column chart with Table2 fields and measure
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.