topic help needed in DAX Commands and Tips

help needed

akas2023 — Sat, 03 Jun 2023 21:30:34 GMT

present in culum chart

Thanks

Re: help needed

Anonymous — Wed, 31 May 2023 02:42:35 GMT

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

Re: help needed

akas2023 — Wed, 31 May 2023 08:09:39 GMT

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%

Re: help needed

Anonymous — Wed, 31 May 2023 08:20:45 GMT

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

Re: help needed

akas2023 — Wed, 31 May 2023 11:00:13 GMT

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

Re: help needed

Anonymous — Thu, 01 Jun 2023 08:58:42 GMT

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.