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 Everyone,
I have a dataset where I am trying to calculate the user response time to dealer note using the note date of every action.
Here is my sample data look like, I've calculated this in hive query using lag, lead, and min window functions, but my user wants to see this in Power BI.
This is what I tried so far.
I've created a "user note date" measure to get the first response of the User response
I am getting this error from Dealer Note Date Measure, I am not understanding what's wrong with the above calculation.
error: A single value for column 'Action Type' in table 'Query1' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min
incident | last user | Action Type | Note Date | Response Time in Hours |
4815911 | DLR_CUST_Update | 9/5/2020 9:20 | ||
4815911 | U01PAAA | VEH_STAT_CHANGE | 9/9/2020 16:08 | 102 |
4815911 | DLR_CUST_Update | 9/17/2020 09:40 | ||
4815911 | U01PAAA | VEH_STAT_CHANGE | 9/17/2020 11:50 | 2 |
4815911 | U01PAAA | VEH_STAT_CHANGE | 9/18/2020 11:47 | |
4815911 | DLR_CUST_Update | 9/19/2020 09:47 | ||
4815911 | U01PAAA | VEH_STAT_CHANGE | 9/20/2020 07:47 | 2 |
Solved! Go to Solution.
Hi @Sharma0815 -
Try this measure. The ALLEXCEPT inside the filter "disconnects" from the original Query1 table, causing the error message you are seeing.
DealerNoteDate =
CALCULATE (
MIN ( Query1[Note Date] ),
KEEPFILTERS ( Query1[incident] ),
FILTER (
Query1,
Query1[Action Type] IN { "DLR_CUST_Update" }
)
)
Hope this helps
David
Hi @Sharma0815 -
Try this measure. The ALLEXCEPT inside the filter "disconnects" from the original Query1 table, causing the error message you are seeing.
DealerNoteDate =
CALCULATE (
MIN ( Query1[Note Date] ),
KEEPFILTERS ( Query1[incident] ),
FILTER (
Query1,
Query1[Action Type] IN { "DLR_CUST_Update" }
)
)
Hope this helps
David
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |