Forum Discussion
Dax function is difficult
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
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.