Forum Discussion

JD09's avatar
JD09
Icon for Advocate I rankAdvocate 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-201...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    JD09 , Try a measure like

    sum(Table[Value]) +0

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

v-weiyan1-msft's avatar
v-weiyan1-msft
Icon for Community Support rankCommunity 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.