cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
pravind96
Frequent Visitor

Creating a measure to Count as 1 when everyday user Check In Twice in Applicaiton

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 MorningCheck In EveningCount as 1
YesYes1
YesNo0
1 REPLY 1
lbendlin
Super User
Super User

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.

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors