Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I don't have much experience with DAX and has done a lot of searches to try and figure out what to do.
My data source contains test grades (1-4 potential) for a given number of students.
I want to create a pie chart that shows me the number of Grade 1's, Grade 2's..etc.
This is easy to do in excel, see 'CountIF' table below the grades.
But in Power BI desktop I think it requires DAX competence?
How do I do this?
Thank you
Solved! Go to Solution.
@Camstr Easiest thing you can do is go into Power Query Editor, select your Name column, right-click and choose "Unpivot other columns". Then you don't need DAX. If for some reason you want to leave your data as is, then you will need something like MC Aggregations: Multi-Column Aggregations (MC Aggregations) - Microsoft Fabric Community
Also, there are equivalents for COUNTIF in DAX: Excel to DAX Translation - Microsoft Fabric Community
@Camstr Easiest thing you can do is go into Power Query Editor, select your Name column, right-click and choose "Unpivot other columns". Then you don't need DAX. If for some reason you want to leave your data as is, then you will need something like MC Aggregations: Multi-Column Aggregations (MC Aggregations) - Microsoft Fabric Community
Also, there are equivalents for COUNTIF in DAX: Excel to DAX Translation - Microsoft Fabric Community
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |