Using a slice selection for measure but not for filtering

Question

Hi,I am working with a power Bi that consists on comparing the user data from one month to the previous one. To do this, i can't use a slice to make the user choose the month because then i have to options:- if I allow the slice to filter the visual object, I don't have the data from the previous month of the selected one (for exemple if user select april, I can't show the comparision with march because data is filtered only by march).- If I don't filter the visual object by the slice but I use the value selected with the SELECTEDVALUE() function, it doesn't take it because it is not filtered by it.&nbsp;If thought in using two slices, that the one depending in the other (it could be that the segond filter took the previous month to the one selected in the first slice or something like this).&nbsp;If you guys have some ideas on it I would be very thankful.&nbsp;Kind regards,Marc

v-yanjiang-msft · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
According to your description, you said that&nbsp;if you allow the slicer to filter the visual, you don't have the data from the previous month of the selected one. But if you create a measure to show the previous month data, it can also work fine with the slicer.
I create a sample.

Here's my solution, create a measure.
Pre =
VAR _Pre =
    DATEADD ( 'Table'[Date], -1, MONTH )
RETURN
    CALCULATE (
        MAX ( 'Table'[Sales] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Date] = _Pre )
    )

Get the correct result.

I attach my sample below for reference.
&nbsp;
Best Regards,Community Support Team _ kalyj
If this post&nbsp;helps,&nbsp;then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

Using a slice selection for measure but not for filtering

2 Replies

Related content

DAX Measure ignore filter/slicer selection

Dynamic measure filtering

Filter by Rank measure

Calculate measure based on Filter selection

Select a measure based on a filter selection