Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 ...
Need Help
  • PC2790's avatar
    PC2790
    4 years ago

    Is tis what you are looking for?

    Attaching the file here for your reference.

  • PC2790's avatar
    PC2790
    4 years ago

    Glad to help ğŸ™‚

    If your issue is resolved, please mark the answer as solution for others to benefit from it.

    Thanks

Anonymous's avatar
Anonymous
Not applicable
4 years ago

PC2790 

 

thx.

 

Should I do it like the image I posted?
It's not working....

 

  • PC2790's avatar
    PC2790
    Community Champion
    4 years ago

    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.