Differences in behavior of ALL, ALLEXCEPT, ALLSELECTED functions when using ADDCULMNS in measure

[Anonymous]

Hi, I made a measure of 3 functions assuming the figure below.

However, ALL SELECTED and ALL behaved differently.

Even though I removed the filter in the "day" column, it behaves as if the filter remains.

I want to know why this happens and the solution. (What I want to make is "Measure_ALL SELECTED".)

thank you.

Measure_ALL =

var table1 = ADDCOLUMNS('table',"measure1",CALCULATE(COUNTROWS('table'),ALL('table'[day])))

RETURN

MAXX(table1,[measure1])

Measure_ALLEXCEPT =

var table1 = ADDCOLUMNS('table',"measure1",CALCULATE(COUNTROWS('table'),ALLEXCEPT('table','table'[value])))

RETURN

measure_ALLSELECTED =

var table1 = ADDCOLUMNS('table',"measure1",CALCULATE(COUNTROWS('table'),ALLSELECTED('table'[day])))

RETURN

MAXX(table1,[measure1])

MAXX(table1,[measure1])

[Anonymous]

I'm sorry.The position of MAXX was wrong. 

Measure_ALL = 
var table1 = ADDCOLUMNS('table',"measure1",CALCULATE(COUNTROWS('table'),ALL('table'[day])))
RETURN
MAXX(table1,[measure1])

Measure_ALLEXCEPT = 
var table1 = ADDCOLUMNS('table',"measure1",CALCULATE(COUNTROWS('table'),ALLEXCEPT('table','table'[value])))
RETURN
MAXX(table1,[measure1])

measure_ALLSELECTED = 
var table1 = ADDCOLUMNS('table',"measure1",CALCULATE(COUNTROWS('table'),ALLSELECTED('table'[day])))
RETURN
MAXX(table1,[measure1])

thank you

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ，

You can try to create a calculated table with the formula of the variable table1 and then see the final table obtained. From the figure below, you can see that the values of measure1 end up with a value of 1. In this case, you apply the date slicer only with the number of records affected. Without applying the date slicer filter, both all() and allselected() will return data like the table below.

If you apply a date filter (day>=2022/1/3) and use allselected, the variable table1 will only display the following 8 rows, and the value of measure1 will still be 1...

You can review the content in the following links to get more details about ALL(), ALLSELECTED and ALLEXCEPT().

ALLSELECTED()

ALL vs ALLSELECTED in DAX and Power BI Desktop

ALL Vs ALLSELECTED Vs ALLEXCEPT DAX FIiter Functions

The (ALL, ALLSELECTED & ALLEXCEPT) Code

Best Regards

[Anonymous]

thank you for your reply
It's easy to check if you use a table.
I will also read the reference.
Thank you!