Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have jobs table listed like below:
I have another table called driver log that looks like the below:
So in pivot above, how do I put a new measure called "Available Drivers".
So pivot should look like this:
Appreciate the help.
Regards,
Bryan
Solved! Go to Solution.
@Anonymous Use this measure to include zone as well in available driver calculation. If it does not work please share sample data to reproduce the scenario
Measure =
VAR _jobDate = MAX(Job[Job date time])
VAR _zone = SELECTEDVALUE(Job[zone])
RETURN CALCULATE(COUNT(DriverLog[Driver id]),FILTER(DriverLog,DriverLog[Login]<=_jobDate && DriverLog[Logout]>=_jobDate && DriverLog[zone]=_zone))
@Anonymous
please create a measure as per below
Measure =
VAR _jobDate = MAX(Job[Job date time])
RETURN CALCULATE(COUNT(DriverLog[Driver id]),FILTER(DriverLog,DriverLog[Login]<=_jobDate && DriverLog[Logout]>=_jobDate))
@Anonymous thanks so much, it seems to be working. Just 1 little issue I have.
Currently, in jobs table, there is a field called 'zone'. This field is used as a slicer in the report.
In driver log table, there is also a field called 'zone'
How to make the measure to also consider selected slicer in the report?
@Anonymous Use this measure to include zone as well in available driver calculation. If it does not work please share sample data to reproduce the scenario
Measure =
VAR _jobDate = MAX(Job[Job date time])
VAR _zone = SELECTEDVALUE(Job[zone])
RETURN CALCULATE(COUNT(DriverLog[Driver id]),FILTER(DriverLog,DriverLog[Login]<=_jobDate && DriverLog[Logout]>=_jobDate && DriverLog[zone]=_zone))
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |