topic Re: Problem with Understanding AllSELECTED in DAX Commands and Tips

Problem with Understanding AllSELECTED

HarsimranPWRBI — Tue, 05 Nov 2019 11:34:09 GMT

Source Data : WideWorldImportersDW-Full.bak

As ALLSELECTED clears the implicit filter for visual it is used in only and keep explicit filter coming from slicer or other visuals.

Running Total (AllSELECTED ) Of Quantity = CALCULATE([Total Sales Quantity], FILTER( ALLSELECTED('Dimension Date'), MAX('Dimension Date'[Date])>='Dimension Date'[Date] ) )

Its hard to understand why below code related to ALLSELECTED in above expression is not re initiating running total for selected calendar year label

ALLSELECTED('Dimension Date'[Date])

It seems like specifying Dimension Date table only and specific column provide all Dimension Date range for selected calender year and hence re-initiating running total.

If that is the case then how can we re-instate running total while using Calendar year label as slicer.

Thanks,
Harry

Re: Problem with Understanding AllSELECTED

Nathaniel_C — Tue, 05 Nov 2019 18:13:10 GMT

Hi HarsimranPWRBI ,

Try inserting a var and a return. You need to capture that value outside of the CALCULATE. Also the test is less than or equal. You will have to put back in your table name and measure name.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

Running Total (AllSELECTED ) Of Quantity = VAR _ddate = MAX ( 'Calendar'[Date] ) RETURN CALCULATE ( [Total Quantity], FILTER ( ALLSELECTED ( 'Calendar' ), 'Calendar'[Date] <= _ddate ) //Less than or equal to )

Re: Problem with Understanding AllSELECTED

HarsimranPWRBI — Wed, 06 Nov 2019 06:07:21 GMT

Hi Nathaniel_C ,

Thanks for the reply but this one is same expression shared in post without variable.

To be more specific, i'm looking for alternate for ALLSELECTED(table) with ALLSELECTED(<column>,..) that can help me achieve same result.

Just to add more info, i'm using Date hierarchy in Visual and CY label as slicer & while using below code for measure in visual does not re-initiate running total for selected CY

Running Total (AllSELECTED Date) Of Quantity = CALCULATE([Total Sales Quantity], FILTER( ALLSELECTED('Dimension Date'[Date]) ,MAX('Dimension Date'[Date])>='Dimension Date'[Date] ) )

Thanks,

Harry