if data not exist in base display blank or 0

[ItSupportElm]

Hello guys,

i have some column from database in Direct Query

Here the result that i want :

Id	Point	email
1	400	xxxxx@gmail.com
2		xxxxx@gmail.com
3	600	xxxxx@gmail.com

Here the explanation what i have :

For the Id 2 , i want to display empty or 0 for the value "Point" but in my base there is no data for this Id , he has no point then the row dosnt exist, cause of that the row with Id 2 dosnt appear in Power BI , is it possible to have a dax formula to fix that ?

(I precise the column point its a Sumx formula).

Thank you, if you need more informations dont hesitate please.

[Pradeep160]

I am facing a similar issue. Tried multiple ways however no luck. Even the "show item with no data" option is making the visual to take lot of time to load. @ItSupportElm  Have you found any other solution?

[amitchandak]

@ItSupportElm , if id is coming from a separate table then a measure with +0

or the option Show item with no data can help

measure =Sum(Table[Point])+0

[ItSupportElm]

Hello @amitchandak thank you for the answer but it didnt work i got this with the measure : 

And without i go this but it didnt appear all the data: 

I dont want use "show item with no data" becausei have so many data , and the loading is so long...