Forum Discussion

Dunner2020's avatar
Dunner2020
Post Prodigy
5 years ago

Measure does not display value in card visualisation

Hi there,

 

I have a measure that calculates the cumulative sum until the end of last month. The measure looks like as follow:

 

cumulative sum =
var CurrentDate = MAX('Outages '[Actual Interruption Start Date Time])
Var lastmonth =EOMONTH(TODAY(),-1)
Var _CYMonth = MONTH(TODAY())
Var _RYMonth = if(_CYMonth > 3 && _CYMonth <= 12, _CYMonth - 3,_CYMonth + 9)

 

Return
sumx(FILTER(ALL('Outages'),'Outages '[Actual Interruption Start Date Time]<=CurrentDate && 'Outages '[Actual Interruption Start Date Time ] <=lastmonth && Month(CurrentDate)<_CYMonth ),
[sum_measure])

The above-mentioned measure works fine when I use in the area chart as shown below:
 

 

However, if I use the same measure in the card visual, it shows blank:

 

I noticed that If I remove the colored text from the below measure then it works fine. However, the calculation is different as it starts considering the current month (after removing the colored text). Did someone encounter the same problem? Any help to fix the issue would be really appreciated.

 

cumulative sum =
var CurrentDate = MAX('Outages '[Actual Interruption Start Date Time])
Var lastmonth =EOMONTH(TODAY(),-1)
Var _CYMonth = MONTH(TODAY())
Var _RYMonth = if(_CYMonth > 3 && _CYMonth <= 12, _CYMonth - 3,_CYMonth + 9)

 

Return
sumx(FILTER(ALL('Outages'),'Outages '[Actual Interruption Start Date Time]<=CurrentDate && 'Outages '[Actual Interruption Start Date Time ] <=lastmonth && Month(CurrentDate)<_CYMonth ),
[sum_measure])

 

 

 

 

 
Need Help
Show and Tell
Tips and Tricks

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Dunner2020 , Formula seem correct , try this one

     

    cumulative sum =
    var lastmonth =EOMONTH(TODAY(),-1)

    Return
    sumx(FILTER(ALL('Outages'),'Outages '[Actual Interruption Start Date Time]<=MAX('Outages '[Actual Interruption Start Date Time]) && 'Outages '[Actual Interruption Start Date Time ] <=lastmonth),
    [sum_measure])

    • Dunner2020's avatar
      Dunner2020
      Post Prodigy
      5 years ago

      amitchandak  Thanks for the response, I tried your suggested one. Following is the output for the new formula

       

      As you can see it starts showing the value of the Current month (i.e. October) and next month (i.e. November). However, it started showing value on the card visual. As I mentioned in my actual post that this cumulative measure shows the cumulative sum until the end of last month. Don't want to show the current and next month.

      • amitchandak's avatar
        amitchandak
        Super User
        5 years ago

        Dunner2020 , As you have not selected any date on page that is why is showing null on card . Because your formula does not go beyond current month.

        Your formula is correct. You need to have filter to see data on card