help needed

[akas2023]

 present in culum chart

Thanks

[v-binbinyu-msft]

Hi @akas2023 ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu

[akas2023]

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%

[v-binbinyu-msft]

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

[akas2023]

The percentage is correct but the problem is I cannot include whole table bcoz of characters limitation.kindly help to how to do.thanks

[v-binbinyu-msft · Accepted solution]

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
    _b

C 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
    _b

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