sum the total of data labels dynamically

[Shubham_Yadav]

Hi, is there any way that i sum the total of data labels dynamically

Here is my DummyPbix->DummyPbix 

Any help will be thankfull.

[FarhanAhmed]

Can you please explain a bit more and share some sample data to understand the problem in detail.

[Shubham_Yadav]

Hi @FarhanAhmed , I want sum of values which you see above each bars, it should be dynamic such that when date filter changes ites value then all summation should also be done dynamically

[v-jingzhang · Accepted solution]

Hi @Shubham_Yadav 

You can try this measure. I used your [Start_Date_Measure] in it. 

Total sum = 
var _date2 = [Start_Date_Measure]+30
return
CALCULATE(SUM(Date_range[value]),ALLSELECTED(Date_range[Date]),Date_range[Date]<_date2)

Removing ALLSELECTED() part is also OK if you only want to display it in a card visual. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.