topic Re: Limit Parameter slicer to be applied to a specific measure in Matrix in DAX Commands and Tips

Limit Parameter slicer to be applied to a specific measure in Matrix

Rabi — Tue, 05 Dec 2023 01:21:20 GMT

Hi Everyone,

I have a matrix visual with MTD and YTD values for expenses with location and account lines. I need MTD to be filtered and i want YTD to remain static, to filter the MTD value i have used a parameter and used slicer from it. How can i limit YTD value to not get affected from the slicer. I also have a relation from table A with the parameter table. The measure for YTD value is as below:

YTD = VAR n = [EXPENSES] VAR d = year(today()) RETURN CALCULATE( n, ALLEXCEPT('Table A', 'Table A'[Date].[Year]), 'Table A'[Date].[Year] = d )

Measure for MTD:

MTD-PARAM = CALCULATE( [EXPENSES], 'Table A'[Month NO] = SELECTEDVALUE('Parameter Table'[Month NO]) && YEAR('Table A'[Date]) = YEAR(TODAY()) )

Thanks For the help.

Re: Limit Parameter slicer to be applied to a specific measure in Matrix

VahidDM — Tue, 05 Dec 2023 04:56:33 GMT

Hi Rabi

Try this:

YTD = VAR CurrentYear = YEAR(TODAY()) RETURN CALCULATE( [EXPENSES], REMOVEFILTERS ( 'Parameter Table' ), YEAR('Table A'[Date]) = CurrentYear )

YTD = VAR CurrentYear = YEAR(TODAY()) RETURN CALCULATE( [EXPENSES], FILTER( ALL('Table A'), YEAR('Table A'[Date]) = CurrentYear ) )

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

LinkedIn | Twitter | Blog | YouTube

Re: Limit Parameter slicer to be applied to a specific measure in Matrix

Rabi — Tue, 05 Dec 2023 05:18:59 GMT

Hi VahidDM ,

The first dax worked perfect as the idea was to remove filter from the parameter slicer. Thanks very much, Absolute legend.

Re: Limit Parameter slicer to be applied to a specific measure in Matrix

VahidDM — Tue, 05 Dec 2023 05:44:40 GMT

Glad it fixed.

Thanks