Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hello Everyone,
I need help. I have a data of patients who visited hospital for their routine checkups. I have 4 data table for my analysis.
All the table have one main category column and one subcategory column. The sample data table of Complaint table is given below for your help:
Patient_ID | Date | Diagnosis_MainCategory | Diagnosis SubCategory |
PAT-10019 | 24/05/2021 | Anaemia | Type-1 Anaemia |
PAT-10019 | 30/03/2022 | Anaemia | Type-2 Anaemia |
PAT-10019 | 25/05/2021 | Anaemia | Type-2 Anaemia |
PAT-10019 | 25/05/2022 | Anaemia | Type-3 Anaemia |
PAT-10019 | 28/03/2022 | Anaemia | Type-3 Anaemia |
PAT-10019 | 06/10/2021 | Anaemia | Type-3 Anaemia |
PAT-10019 | 09/11/2021 | Anaemia | Type-3 Anaemia |
PAT-10019 | 03/01/2022 | Anaemia | Type-4 Anaemia |
PAT-10019 | 21/01/2021 | Anaemia | Type-4 Anaemia |
PAT-10019 | 24/05/2021 | Anaemia | Type-4 Anaemia |
PAT-10019 | 16/02/2022 | Anaemia | Type-4 Anaemia |
PAT-10197 | 10/05/2022 | Pneumonia | Type-1 Pneumonia |
PAT-10197 | 29/01/2021 | Pneumonia | Type-2 Pneumonia |
PAT-10197 | 17/06/2021 | Pneumonia | Type-2 Pneumonia |
PAT-10197 | 18/03/2022 | Pneumonia | Type-3 Pneumonia |
PAT-10197 | 30/12/2020 | Pneumonia | Type-3 Pneumonia |
PAT-10197 | 30/12/2020 | Pneumonia | Type-3 Pneumonia |
PAT-10197 | 30/12/2020 | Pneumonia | Type-4 Pneumonia |
PAT-10197 | 30/12/2020 | Pneumonia | Type-4 Pneumonia |
PAT-10197 | 30/12/2020 | Pneumonia | Type-4 Pneumonia |
PAT-10197 | 30/12/2020 | Pneumonia | Type-4 Pneumonia |
All these table connected with patient ID in data model. I need to calculate the below mentioned measure from the above 4 tables.
I have created my TOPN, and others measure but it not working dynamically, and I am unable to open OTHERS category in a separate chart.
I will share my sample PBIX file if required.
Thanks,
Sid
Dear All,
Below is the link of my Sample PBIX file for your help
https://www.dropbox.com/s/p6lw8yznb3hjwob/Sample_Data.pbix?dl=0
I have calculated top 3 + Others but i am unable to show the complaints which are falling in REMAINING CATEGORY if we use Top 3.
Thanks,
Sid
Looking for help
Hello All,
Any suggestions from you ??
@siddiq8686khi , Refer if these 2 can help
https://www.youtube.com/watch?v=JLK2e0k8OBE
@amitchandak Thanks for the reply. Actually i also need to calculate "Others ( All those who left after TopN will be shown as Others in Chatrts) means, if we will show a donut chart then there will be 6 slices - 5 slices for top5 and 1 for Others.
Thanks,
Sid
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.