I have problem a with IF statement for the second table (its a bit complicated but i will try and explain it)
I have 2 tables linked together FIXED MONTH and MONTH 2 is linked together. The slicer Month is table not linked to anyone. What shuld happen is that i choose a value in the slicer , the left table is checked if slicervalue = MONTH 1 and < FIX MONTH with seems to work as seen on the measure "Check" "YES" The MATTE Measure is cheeking "Check" , IF YES then FIX VALUE , witch also works on the left table. This should now be applied to the right table and the measure "MATTE" values should be added on right table using the FIX MONTH as month , and as u can see it works on 2 of the 5 values.I do not understand why the 21 value (MONTH 1 201805 , FIX MONTH 201902) , value 4 (MONTH 1 201805 , FIX MONTH 201904) and value 6 (MONTH 1 201805 , FIX MONTH 201906) is not added to the right table.
There is other strange things if i choose some other slicer value , if i choose 201802 on the slicer everything is found on the left table as it should but not shown on the right table as it should
I hope that i have explained the problem well. Help really appreciated