value < 24 , not returning 0 values in DAX.

[Anonymous]

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?

• [summ]<24 || [summ]=0
• [summ]<24 || [summ] = BLANK()
• [summ]<24 || [summ] is BLANK

Or shall I create a new/different summarize?

[v-zhangti · Accepted solution]

Hi, @Anonymous 

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.

[ValtteriN]

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/