topic Re: value < 24 , not returning 0 values in DAX. in DAX Commands and Tips

value < 24 , not returning 0 values in DAX.

Anonymous — Wed, 09 Feb 2022 15:56:03 GMT

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?

Re: value < 24 , not returning 0 values in DAX.

ValtteriN — Wed, 09 Feb 2022 16:07:11 GMT

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/

Re: value < 24 , not returning 0 values in DAX.

v-zhangti — Mon, 14 Feb 2022 09:22:03 GMT

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.