Forum Discussion

ItSupportElm's avatar
ItSupportElm
Icon for Helper III rankHelper III
5 years ago

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
1400[email protected]
2 [email protected]
3600[email protected]

 

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.

DAX
SQL
tips & tricks

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    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's avatar
      ItSupportElm
      Icon for Helper III rankHelper III
      5 years ago

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

  • Pradeep160's avatar
    Pradeep160
    Frequent Visitor
    3 years ago

    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?