cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ItSupportElm
Helper III
Helper III

if data not exist in base display blank or 0

Hello guys,

 

i have some column from database in Direct Query

 

Here the result that i want :

 

IdPointemail
1400xxxxx@gmail.com
2 xxxxx@gmail.com
3600xxxxx@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.

2 REPLIES 2
amitchandak
Super User
Super User

@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

 

ShowItemwithoutdata.JPG

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

 

2021-05-17_10h52_24.png

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

2021-05-17_10h52_42.png

 

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

Helpful resources

Announcements
T-Shirt Design Challenge 2023

Power BI T-Shirt Design Challenge 2023

Submit your creative T-shirt design ideas starting March 7 through March 21, 2023.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!