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 ...
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
You can go to the url address and download the file.
PC2790
https://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.