Forum Discussion

Fireoyster's avatar
Fireoyster
New Member
1 year ago
Solved

Table Query

Hello, New to Bi looks awesome. I am looking to find out how I can create a table listing the students and the number of times they have taken the class. any help would be appreciated.   Student...
Need Help
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    1 year ago

    Hi Fireoyster,
    Thank you for reaching out to the Microsoft fabric community forum. 

    After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have used it as sample data on my end and successfully implemented it.    

    I am also including .pbix file for your better understanding, please have a look into it:

    If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

    Thank you for using Microsoft Community Forum.

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
1 year ago

Hi Fireoyster 

 

Welcome and I'm sure you all enjoy the experience of the community and learning a lot as you go through this process with. regards to your question and what you're looking for is to create a dax measure which will count the number of students. There is a sample below. How do you create this based on your example above?

 

Course Count = DISTINCTCOUNT('TableName'[Course])

 

Put this measure into a table, then drag in the Name to get a count of how many courses the student took.