Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hello! I am trying to create a report for Temperature Check in daily for my organization use. A staff need to check in the application twice a day, which is morning and evening. Can we create a measure that count as 1 when a user check in twice a day ?
Example:
| Check In Morning | Check In Evening | Count as 1 |
| Yes | Yes | 1 |
| Yes | No | 0 |
1. you don't need a measure for that as the result is not impacted by any filters - use a calculated column or do it in Power Query
2. your data model is a bit iffy. usually you want to unpivot your data to make it easier to use later.
Check out the November 2025 Fabric update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!