Measure context issue

[Anonymous]

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]

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]

Hello @lbendlin,

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

[v-rzhou-msft]

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.

[v-rzhou-msft · Accepted solution]

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.