Getting Value = 0 for the Row That does not exists

[JD09]

Hello,
I have the following sample data:

Load, Month Year, Value
A, Jan-2019, 100
B, Jan-2019,200
C, Jan-2019,300
A, Feb-2019, 100
C, Feb-2019,300
A, Mar-2019, 100
B,Mar-2019,200
C, Mar-2019,300

Expected Output:

Wanted to have Value = 0 (Instead of Blank) For Load = B & Month-Year = Feb-2019, Sample data does have this Row,
How to achieve this scenario.
Thank You!!

[amitchandak · Accepted solution]

@JD09 , Try a measure like

sum(Table[Value]) +0

[v-weiyan1-msft · Accepted solution]

Hi @JD09 ,

You can consider the method mentioned by @amitchandak .
You can also consider the following method to solve the problem.
1. Please try code as below to Create a Calculated table.

Table 2 = VALUES('Table'[Load])

2. Use the following code to create Measure.

Value_Measure =
VAR Val = SELECTEDVALUE ( 'Table'[Value] ) 
RETURN 
IF ( ISBLANK ( Val ), 0, Val )

Result is as below.

Best Regards,
Yulia Yan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JD09]

Thank You @v-weiyan1-msft  !!

[amitchandak · Accepted solution]

@JD09 , Try a measure like

sum(Table[Value]) +0

[JD09]

Thank you @amitchandak