Created table not showing 0 after a group by in the source table

[jramon]

Hello,

I,m having an issue trying to get the value 0 when creating a table.

I,m creating the table:

MONTHDIFF = CALCULATETABLE(GROUPBY(EXIT_RENEWALS_COMINGEXITS,EXIT_RENEWALS_COMINGEXITS[EXIT_RENEWAL_MONTHSDIFF]),FILTER(EXIT_RENEWALS_COMINGEXITS,EXIT_RENEWALS_COMINGEXITS[EXIT_RENEWAL_MONTHSDIFF]<>blank()))

this table takes the values from EXIT_RENEWALS_COMINGEXITS[EXIT_RENEWAL_MONTHSDIFF], that has a range of values from -30 to 30 and some blanks, its type its integer, for some reason is taking all the values besides the 0 any clue why?

If my question is not clear please tell me, and I will try to elaborate it a bit more.

thanks for your help.

[v-xiaotang]

Hi @jramon 

Try this,

MONTHDIFF = CALCULATETABLE(GROUPBY(EXIT_RENEWALS_COMINGEXITS,EXIT_RENEWALS_COMINGEXITS[EXIT_RENEWAL_MONTHSDIFF]),FILTER(EXIT_RENEWALS_COMINGEXITS,NOT(ISBLANK(EXIT_RENEWALS_COMINGEXITS[EXIT_RENEWAL_MONTHSDIFF]))))

And its reason is,

https://docs.microsoft.com/en-us/dax/dax-operator-reference#comparison-operators

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[jramon · Accepted solution]

Hello @v-xiaotang 
I finally decided to create a separate table with a sequence of numbers including 0, but I will try your solution and let you know if it works, it probably will, thanks for the explanation and for your time!