Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
The intention is to present the number of examinations per month with the number of times that a study had been supplemented positively with the percentage of the number of positive results in relation to the number of examinations.
In the example below, column ID_NUMERIC is the examinations number. Column DESCRIPTION is the name of the survey and if the result positive.
Does anyone have an idea how to best handle this in power bi?
Explain column DESCRIPTION values:
Onderzoek-1 en onderzoek-2 are the examinations
Positief tell’s if an examination returned positive
Solved! Go to Solution.
Hi @icturion
Try these MEASURES
Total # of Exams = Calculate(Countrows(TableName),TableName[DESCRIPTION]="Onderzoek-1") Total # of Positives = Calculate(Countrows(TableName),TableName[DESCRIPTION]="Positief") %age = [Total # of Positives]/[Total # of Exams]
Hi,
Try this
Total # of Exams = Calculate(Countrows(TableName),TableName[DESCRIPTION]="Onderzoek-1"||TableName[DESCRIPTION]="Onderzoek-2")
Hope this helps.
Hi @icturion
Try these MEASURES
Total # of Exams = Calculate(Countrows(TableName),TableName[DESCRIPTION]="Onderzoek-1") Total # of Positives = Calculate(Countrows(TableName),TableName[DESCRIPTION]="Positief") %age = [Total # of Positives]/[Total # of Exams]
thank you for the quick respons.
how can I add two different studies in the first measure?values are onderzoek-1 and onderzoek-2
Hi,
Try this
Total # of Exams = Calculate(Countrows(TableName),TableName[DESCRIPTION]="Onderzoek-1"||TableName[DESCRIPTION]="Onderzoek-2")
Hope this helps.
You are welcome.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |