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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |