Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Matrix, some rows are selected:
1) DayCount = DISTINCTCOUNT('time'[DATE].[Day])
Gives the number of days selected, here - 2.
2) HoursCount = [DayCount] * 24
Self-explanatory;
Column from the initial table:
3) DURATION
All values are taken from that column. With selection above I get
48 hours for 2 days, and so on. All good so far. But:
Percent = 'time'[DURATION] (48) / [DayCount] (2)
Gives me 48 for some reason, and not 24.
What goes wrong here?
Solved! Go to Solution.
I figured it out, pretty stupid.. I just had to remove time from the column for values to be distinct. Simple type change didn't do the trick for some reason, I had to split column in parts. Thanks for your time everyone!
I figured it out, pretty stupid.. I just had to remove time from the column for values to be distinct. Simple type change didn't do the trick for some reason, I had to split column in parts. Thanks for your time everyone!
Hi @GrayStrider,
The culprit may be the .[day] part, I threw some data together and when I include the .[day] it behaves strangely, but when you remove it and just do a distinctcount on the 'time'[DATE] I was able to get the expected results
Hope that helps
Well, not sure what can I do with that, unfortulately; unless someone has another solution for counting days. Here's data sample:
3.13 | Tea | leisure | 16-07-18 | |
0.049 | Self-care | maintenance | 16-07-18 | |
0.141 | Job - Idle, Commuting, Planning, ... (Maintenance) | Job | 16-07-18 | |
0.415 | Eating, cooking, shopping, kitchen | maintenance | 16-07-18 |
It's from a time tracker.
Pretty please?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |