Ignore Value if no date

[micmat]

Date	Location	Product	Value
11/25/2019	US	A	20
11/25/2019	US	B	30
11/26/2019	US	A	50
11/27/2019	US	A	30
11/27/2019	US	B	60

Hey all, so what I would like to do is have the chart show the value of Product B - Product A, but only if they both have a given date. So:

11/25/2019 : 10

11/26/2019: Show nothing (no line) since there is no product B for that date

11/27/2019: 30

I tried using some NOT(ISBLANK()) logic but it made my charts look off and not the correct results. Thanks for any help!

[parry2k]

@micmat are you looking for this result

[parry2k · Accepted solution]

@micmat I did with following measures

Total Value = SUM ( 'Table (2)'[Value] )

Product A Value = CALCULATE ( [Total Value], 'Table (2)'[Product] = "A" )

Product B Value = CALCULATE ( [Total Value], 'Table (2)'[Product] = "B" )

Product B - Product A = 
IF ( [Product A Value] = BLANK() || [Product B Value] == BLANK(), BLANK(), [Product B Value] - [Product A Value]
)

Use bar chat, drop date on X-Axis and Product B - Product A on value section

[micmat]

Thank you!

[micmat]

That is exactly it! How were you able to do it?