Calculated Measure will not display any values unless using Specified Column??

[Euro0681]

I am trying to calculate the difference between "Expected received" date and "Actual received Date" by using DateDiff().

Both come from two different tables Expected = Table1(expectedReceivedDate) && Actual = Table2(actualReceivedDate), both tables are related to each other. The calculation works and displays correct values.
The issue im having is the calculate measure only displays values when using the "Actual Received Date" Column in my Visual, WHY??? (live connection mode)
Reference Picture Below!

[AilleryO]

Hi,

It is because you are using the SELECTEDVALUE function which is supposed to receive the value from the context (visual) filtered down to one value.

Unless you're using another function (VALUES, MAX, MIN...) you will be "forced" to have the columnin your visual.

Let us know what you finally did ?

[Euro0681]

This is what i figured as this was my last attempt before asking, as im trying to find a work around. I will post if a solution is found!

[v-yinliw-msft]

Hi @Euro0681 ,

Has your problem been solved? If so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yinliw-msft]

Hi @Euro0681 ,

This may be the measure problem. I test the data below:

Measure:

Measure = ABS(DATEDIFF(MAX('Table'[Actual Receipt Date]),MAX('Test Table'[Expected Receipt Date]),DAY))

And it can show the measure correctly.

Could you please provide your measure functions?

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Euro0681]

This solved the issue of having to use the specified column, but not the calculation is incorrect (as seen in the image below).  I also exluded the abs() as i need negative numbers to count the orders that arrived early

My Original Measure:
Measure = DateDiff(SelectedValue('Table1'[Actual Receipt Date), SelectedValue('Table2'[Expected Receipt Date]),DAY)