Forum Discussion

JohnLow's avatar
JohnLow
Icon for Helper I rankHelper I
5 years ago
Solved

Using a measure on a line chart.

Hi,    I'm currently having an issue with a measure on a line chart and when I try to run a filter, it just disappears.  I created a measure as follows:  Measure15 = CALCULATE(SUM('Table (2)'[Bu...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

  • HotChilli's avatar
    HotChilli
    5 years ago

    SAMEPERIODLASTYEAR works best with a Date table, so create a date table (with a date column and year column), link it your fact table, and replace any field in the visuals with appropriate fields from the date table.

    Change the measure to :

    Measure15 = CALCULATE(SUM('Table (2)'[Budget total]), SAMEPERIODLASTYEAR(TableDates[Date]))

     

    Good luck.

JohnLow's avatar
JohnLow
Icon for Helper I rankHelper I
5 years ago

Brilliant, thank you. 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

You are welcome.