topic Re: if data not exist in base display blank or 0 in DAX Commands and Tips

if data not exist in base display blank or 0

ItSupportElm — Wed, 12 May 2021 13:13:58 GMT

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.

Re: if data not exist in base display blank or 0

amitchandak — Wed, 12 May 2021 14:09:55 GMT

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

Re: if data not exist in base display blank or 0

ItSupportElm — Mon, 17 May 2021 08:55:05 GMT

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...

Re: if data not exist in base display blank or 0

Pradeep160 — Fri, 30 Jun 2023 06:07:34 GMT

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?