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.
Hi all,
I am trying to count the number of documents that have been created and completed in a given/selected day and look at it for each hour. I want to count the number of documents at each hour and it be a cumlative total.
CreatedCount = CALCULATE( COUNTA(IMSDocuments[Creation Date]) + 0, FILTER(ALL(IMSDocuments), IMSDocuments[CreationHour] <= MAX(IMSDocuments[CreationHour])), USERELATIONSHIP(Times[Time], IMSDocuments[CreationHour]), USERELATIONSHIP(Dates[Date], IMSDocuments[Creation Date]) )
Currently my DAX looks like this. I have the ... <= MAX(...) in the expression, but it still doesn't add up right. For 12th Feb 2018, created should total 120 and completed should total 93.
I have a scaled back version of my report which still has all the necessary relationships.
https://drive.google.com/file/d/1nryyr0IdUjjQTQi81v_G6RyS2d_DI-A2/view?usp=sharing
Can anyone see where I am going wrong?
Thanks in advance!!
Solved! Go to Solution.
Is this what you want ??
That's it! Amazing!
Thank you!
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |