Forum Discussion

Gavin_Shales's avatar
Gavin_Shales
Frequent Visitor
8 years ago

I need to sum a Measure with a Calculated Column

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.

 

 

 

 

Need Help

1 Reply

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    8 years ago

    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? :smileyhappy:

     

    Regards