When relationship is not found set value to 100

[Anonymous]

Hello Experts,

Im running in to the following problem: I have 2 tables:

Calender

Date		datekey		More calender stuff
1/1/2020		01012020		etc
1/2/2020		01022020		etc
1/3/2020		01032020		etc

values

Datekey		value
1012020		55
1032020		12

They ofcourse have a relationship on datekey.

I created visuals based on the values. But now i want the following. 

If the datekey exists in calender table but not in the values table it should show a value of 100. 

I tried using EXCEPT but i couldnt get it to work. Anyone of you who did this before and can help me out? 

[amitchandak]

@Anonymous , try like

 Measure  = if (sum(Table[Value])+0=0,100, sum(Table[Value]))+0

[Anonymous]

This indeed could work. But i figured out that there are also values of 0. And that would result in more 100's then we would like. 

[AllisonKennedy]

@Anonymous 

Try using ISBLANK

Measure  = IF(ISBLANK(SUM(Table[Value])),100, SUM(Table[Value]))

[Anonymous]

This works indeed. I thought isblank wont work because there is no record anyway. but it does 😄

[Anonymous]

How about this?

= IF(ISNUMBER(SUM([value]), 100,0)