Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a DAX code where I am doing:
var Final1 = FILTER( SUMMARIZE(NextWeekCS,'Staffing'[DW_EK_Employee],'Date'[Week Year Week Number],"summ", SUM(Staffing[Hours]) ), [summ]<24 ) Var final = SUMMARIZE(final1, 'Staffing'[DW_EK_Employee])
But there is cases where the summ is 0, and my query is not retrieving those results:
I tend to think in a sql-way... is it correct to apply either?
Or shall I create a new/different summarize?
Solved! Go to Solution.
Hi, @ovonel
What do you expect the output to be? The final output of the Dax you have written is a table.
Table =
SUMMARIZE (
FILTER (
SUMMARIZE (
Staffing,
'Staffing'[DW_EK_Employee],
"summ", SUM ( Staffing[Hours] )
),
[summ] < 24
),
[summ]
)
Can you provide some data for testing? What do you expect the final result to look like and can you show it in a screenshot.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @ovonel
What do you expect the output to be? The final output of the Dax you have written is a table.
Table =
SUMMARIZE (
FILTER (
SUMMARIZE (
Staffing,
'Staffing'[DW_EK_Employee],
"summ", SUM ( Staffing[Hours] )
),
[summ] < 24
),
[summ]
)
Can you provide some data for testing? What do you expect the final result to look like and can you show it in a screenshot.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
It is somewhat hard to judge this since I am not sure how much data you are dealing with, but I would go with the second option. Additionally depending on your end goal, I would use functions like SUMX in the second variable/ end result. e.g. if you want to have hours in a filter context SUMX(final1,[summ]) should be useful. Finally, these sort of iterative SUMMARIZE structures are rarely optimal and depending on your end goal it might be good to rethink your apporach.
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Proud to be a Super User!
User | Count |
---|---|
57 | |
21 | |
21 | |
19 | |
16 |
User | Count |
---|---|
86 | |
84 | |
52 | |
37 | |
23 |