How to do Sum of a measure and column value

[ashc_cool10]

Hi There,

I am struggling to create a simple calculation and it might be sound so silly but please help me.

I am trying to create Sum of two values(A+B) in which A is a calculative Measure and B is Column present in data.

I am not sure what logic i am missing. Request you to please help.

Please see below data with desire result:

I hope to receive answer soon. @Greg_Deckler @Ashish_Mathur  please help.

Thanks 

Ashish

[Anand24]

@ashc_cool10 ,
Please post your solution here and mark it as a solution so that others with similar issue would find help !

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[ashc_cool10 · Accepted solution]

Hi @Anand24 

So i have just created one more meausre where i took the Sum of that Sales Column

Measure_2=sum(Sales)

and then i simply added both of the measures:

Total =[Cummulative Total]+[Measure_2]

Regards,

Ashish

[Anand24]

Hi @ashc_cool10 ,
Try the below DAX in a new measure:

Total = [Cummulative Total] + SUM(Sales)

 This is with an assumption that "Cummulative Total" is name of calculated measure and "Sales" is the name of column.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[ashc_cool10]

Hi @Anand24 ,

I already treid this but values are not coming right.

here [Better RT] is measure and HSLVT is our column which is available in data 

54014036.1+49327817=103341853

here vlaues in Total_2 in row 1st should appear 54014036.1+49327817=103341853 

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[ashc_cool10]

Hi @Ashish_Mathur ,

I am able to solve this issue but thanks again for your prompt resposne.

Thanks,

Ashish

[Ashish_Mathur]

You are welcome.

[Greg_Deckler]

@ashc_cool10 Check the implicit aggregation on HSLVT in your table. Make sure it is Sum and not something like Min or Max or Average. If it is, then change SUM to MIN, MAX, AVERAGE, etc.

[ashc_cool10]

Hi @Greg_Deckler ,

It was in SUM only and fortuantely i am able to solve that issue.

Cheers!

Ashish