topic Measure context issue in DAX Commands and Tips

Measure context issue

Anonymous — Thu, 03 Feb 2022 16:56:56 GMT

Hello Everyone,

I am coming to you guys because I have an issue regarding a measure that I was not able to solve yet:

What I would like is to filter Date TO Compare (FIELD of TABLE1) with the Non Context Date (Measure with ALLSELECTED(TABLE1)).

I am doing the following command:

Max TEST 3 = CALCULATE(DISTINCTCOUNT(TABLE1.FIELD1), FILTER(TABLE1, TABLE1.DateToCompare <= TABLE1.NonContextDate))

However, it seems the Context Date is used instead of Non Context Date.

Here the result:

Thank you, in advance, for your help.

Regards,

Thomas

lbendlin — Fri, 04 Feb 2022 13:54:41 GMT

Not clear what your actual issue is. What is the expected outcome?

Max TEST 3 = CALCULATE(DISTINCTCOUNT(TABLE1.FIELD1), FILTER(ALL(TABLE1), TABLE1.DateToCompare <= TABLE1.NonContextDate))

Anonymous — Mon, 07 Feb 2022 13:08:49 GMT

Thank you for your time.

Expected outcome should be for the last row 1 instead of BLANK.any

NonContextDate = CALCULATE(MAX(ContextDate), ALLSELECTED(TABLE1))

But It seems it ignored the ALLSELECTED within Max TEST 3 measure.

Regards,

Thomas

Anonymous — Mon, 14 Feb 2022 10:09:50 GMT

Hi Anonymous ,

NonContextDate = CALCULATE(MAX('TABLE1'[Context Date]),ALLSELECTED(TABLE1))

ALLSELECTED will cause some problem if you use it directly. You can try ALL function or you can try this code.

Max TEST 3 = VAR _ADD = ADDCOLUMNS ( TABLE1, "NonContextDate", [NonContextDate] ) RETURN COUNTAX ( _ADD, [NonContextDate] )

Result is as below.

Best Regards,
Rico Zhou

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