I need to sum a Measure with a Calculated Column

[Gavin_Shales]

Hi,

I am really struggling to find a way to create a new measure made from summing an existing Measure with a Calculated Column.

Can this be acheived? Or do I have to somehow convert my Column to a Measure?

Here is my Calculated Column;

Email_Inbox_new = LOOKUPVALUE(Reporting_ClaimsInput[EmailsInboxOutstanding],Reporting_ClaimsInput[Date],CALCULATE(LASTNONBLANK(Reporting_ClaimsInput[Date], 1), FILTER(Reporting_ClaimsInput,Reporting_ClaimsInput[EmailsInboxOutstanding]>0 && EARLIER(Reporting_Ref_Day[Date])>=Reporting_ClaimsInput[Date])))

I am flexible to changing my approach. Perhaps the above Column can be re-written to work for a Measure?

Thanks.

[v-ljerr-msft]

Hi @Gavin_Shales,

Could you post your table structures with some sample/mock data, and the expected result? So that we can better assist on this issue? 

Regards