Forum Discussion
Dax function is difficult
Hello, I'm a beginner at Power B.I
There are seven classrooms and there should be seven people per classroom.
Then, you can receive a total of 49 people with a total of 7*7=49, and now 23 people have entered the school, so you have to fill 26 more people.
As you can see in the image, a total of 26 numbers are shown, but if you click each class, the numbers are not correct.
I want to get a number normally.
I need your help
Thank you.
Is tis what you are looking for?
Attaching the file here for your reference.
Glad to help 🙂
If your issue is resolved, please mark the answer as solution for others to benefit from it.
Thanks
8 Replies
Try:
Measure =
var studentsperclass = 7return
Calculate('Class',Class[Class] * studentsperclass - freshman[entrance into a school])
Make sur eyou ahve relationship between Class and freshman table
Can you provide your data model and sample data?
What data type is you class column?
If each class has 7 students and it is fixed then there is no need to multiply it explicitly with 7.
If your Class table contains the number of students, you can get the 7 number from there using:
Measure =
var selectedclass = Allselected(Class[Class])var Noofstudentsinclass = Count(Filter('Class', Class[Class] = selectedclass))
return
Noofstudentsinclass - freshman[entrance into a school]
If single class has 7 students, then Noofstudentsinclass would always return 7 if one class is selected?Isn't it?
And are you sure you want to subtract freshman[entrance into a school]?
It will be easier to advice further if you can provide some sample data and your expected output.
You can go to the url address and download the file.
PC2790https://drive.google.com/drive/folders/1DIDO3Wuw3jj0I9A03eszMfRkk5bQ31RV?usp=sharing
You can go to the url address and download the file.
The powerbi should have a value in the 'card' part.
-> need to STU = (each class * 7) - Total number of students enrolled
And if you press each classroom, you can see the number of students that you need
For example, if you press A, the number "card" should be 5 people
It's because two people are currently in class A.You can go to the url address and download the file.
The powerbi should have a value in the 'card' part.
-> need to STU = (each class * 7) - Total number of students enrolled
And if you press each classroom, you can see the number of students that you need
For example, if you press A, the number "card" should be 5 people
It's because two people are currently in class A.URL : https://drive.google.com/drive/folders/1DIDO3Wuw3jj0I9A03eszMfRkk5bQ31RV?usp=sharing