Forum Discussion

JD09's avatar
JD09
Advocate I
2 years ago
Solved

Getting Value = 0 for the Row That does not exists

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

Need Help
  • v-weiyan1-msft's avatar
    v-weiyan1-msft
    2 years ago

    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.

4 Replies

  • v-weiyan1-msft's avatar
    v-weiyan1-msft
    Community Support
    2 years ago

    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.