Percentange Difference on selected Years only

Question

Hi all ,Here is my Question again ,i&nbsp; am getting year over year&nbsp; % Difference by using Quick measure&nbsp;&nbsp; or Dax&nbsp; calculations. But my question is , if I select years randomly from the slicers it is displaying on the previous year difference only not with the selected years as shown in below images.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;everything i need is to calculate the year over year difference on the selected&nbsp; year from slicers ,&nbsp; and if&nbsp; all years selected&nbsp; it has to display the previous year difference.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Thanks&nbsp;Umesh&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

v-chuncz-msft · Accepted Answer

Umeshp,
&nbsp;
You may add the following measure.
Measure =
VAR y =
    MAXX (
        FILTER (
            ALLSELECTED ( Table1[Year] ),
            Table1[Year] &lt; SELECTEDVALUE ( Table1[Year] )
        ),
        Table1[Year]
    )
VAR prev =
    CALCULATE ( [total], Table1[Year] = y )
RETURN
    IF ( NOT ( ISBLANK ( prev ) ), DIVIDE ( [total] - prev, prev ) )

Forum Discussion

Percentange Difference on selected Years only

1 Reply

Related content

Different schema into different destination

Color based on slicer selection but with different forms, Scatter chart

How to select different dates

Select three different columns using measure

Appending Selected Columns from Different Tables