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.
Hello,
I am trying to make a DAX to sum the distinct counts of Names per timestamp and display the result per hour. See the example below
assigned | Score | DateOfAnalysis-Date | DateOfAnalysis-Hour |
A | 10.00% | 7/25/2023 0:00 | 1899-12-30 15:04:00 |
B | 10.00% | 7/25/2023 0:00 | 1899-12-30 15:04:00 |
C | 125.00% | 7/25/2023 0:00 | 1899-12-30 15:04:00 |
D | 100.00% | 7/25/2023 0:00 | 1899-12-30 15:04:00 |
E | 50.00% | 7/25/2023 0:00 | 1899-12-30 15:04:00 |
G | 60.00% | 7/25/2023 0:00 | 1899-12-30 15:04:00 |
H | 70.00% | 7/25/2023 0:00 | 1899-12-30 15:04:00 |
I | 110.00% | 7/25/2023 0:00 | 1899-12-30 15:04:00 |
J | 25.00% | 7/25/2023 0:00 | 1899-12-30 15:04:00 |
K | 10.00% | 7/25/2023 0:00 | 1899-12-30 15:04:00 |
L | 45.00% | 7/25/2023 0:00 | 1899-12-30 15:04:00 |
M | 40.00% | 7/25/2023 0:00 | 1899-12-30 15:04:00 |
N | 10.00% | 7/25/2023 0:00 | 1899-12-30 15:04:00 |
O | 50.00% | 7/25/2023 0:00 | 1899-12-30 15:04:00 |
P | 50.00% | 7/25/2023 0:00 | 1899-12-30 15:04:00 |
C | 125.00% | 7/25/2023 0:00 | 1899-12-30 15:28:54 |
D | 100.00% | 7/25/2023 0:00 | 1899-12-30 15:28:54 |
G | 110.00% | 7/25/2023 0:00 | 1899-12-30 15:28:54 |
H | 70.00% | 7/25/2023 0:00 | 1899-12-30 15:28:54 |
I | 60.00% | 7/25/2023 0:00 | 1899-12-30 15:28:54 |
J | 25.00% | 7/25/2023 0:00 | 1899-12-30 15:28:54 |
K | 10.00% | 7/25/2023 0:00 | 1899-12-30 15:28:54 |
L | 45.00% | 7/25/2023 0:00 | 1899-12-30 15:28:54 |
M | 40.00% | 7/25/2023 0:00 | 1899-12-30 15:28:54 |
N | 10.00% | 7/25/2023 0:00 | 1899-12-30 15:28:54 |
O | 60.00% | 7/25/2023 0:00 | 1899-12-30 15:28:54 |
P | 60.00% | 7/25/2023 0:00 | 1899-12-30 15:28:54 |
C | 125.00% | 7/25/2023 0:00 | 1899-12-30 15:53:37 |
D | 100.00% | 7/25/2023 0:00 | 1899-12-30 15:53:37 |
F | 50.00% | 7/25/2023 0:00 | 1899-12-30 15:53:37 |
G | 160.00% | 7/25/2023 0:00 | 1899-12-30 15:53:37 |
H | 70.00% | 7/25/2023 0:00 | 1899-12-30 15:53:37 |
I | 60.00% | 7/25/2023 0:00 | 1899-12-30 15:53:37 |
J | 25.00% | 7/25/2023 0:00 | 1899-12-30 15:53:37 |
K | 10.00% | 7/25/2023 0:00 | 1899-12-30 15:53:37 |
L | 45.00% | 7/25/2023 0:00 | 1899-12-30 15:53:37 |
M | 30.00% | 7/25/2023 0:00 | 1899-12-30 15:53:37 |
N | 50.00% | 7/25/2023 0:00 | 1899-12-30 15:53:37 |
O | 10.00% | 7/25/2023 0:00 | 1899-12-30 15:53:37 |
P | 60.00% | 7/25/2023 0:00 | 1899-12-30 15:53:37 |
The result I get in PBI with the formula EngineerPerDoA = sumx(values(imtScoreData[DateOfAnalysis-Hour]),DISTINCTCOUNT(imtScoreData[assigned])) I get the correct result per timestamp 15, 12 and 13.
Now when I want to display this per hour, I get 48 as a result instead of 40
How can I make a formula to sum those 15,12,13 values to display the 40 in my hour bin layout ?
thank you
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |