Forum Discussion
JD09
Advocate I
2 years agoGetting 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...
- 2 years ago
JD09 , Try a measure like
sum(Table[Value]) +0
- 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.
amitchandak
Super User
2 years agoJD09 , Try a measure like
sum(Table[Value]) +0
- JD092 years ago
Advocate I
Thank you amitchandak