Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I really apreciate if any one can help me with this problem
ID School | Level | Service | Qty |
101 | primary school | Lunch | 20 |
101 | primary school | Breakfast | 18 |
101 | primary school | snacks | 7 |
101 | high school | Lunch | 30 |
101 | high school | Breakfast | 40 |
602 | primary school | Lunch | 10 |
602 | primary school | Breakfast | 21 |
602 | high school | Lunch | 25 |
602 | high school | Breakfast | 15 |
Max qty by service in
ID 101
for primary school is 20,
For high shcool is 40
in ID 602
for primary school is 21,
For high shcool is 25
Expected measure result is 20+40+21+25 =106
Solved! Go to Solution.
@Anonymous , as I understood the ID school and schoollevel belonging together, so you can summarize them. Please take a look at Measure:
Hello,
Hello,
@Anonymous , as I understood the ID school and schoollevel belonging together, so you can summarize them. Please take a look at Measure:
Thanks a lot!! works excelent!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
94 | |
82 | |
70 | |
64 |
User | Count |
---|---|
116 | |
106 | |
94 | |
79 | |
72 |