Using VALUES + ALL instead of just ALL. Resolution included - Need to know WHY it works

^{Hi prill22ta ,}

^{Using a single column argument, ALL returns all the unique values of the column.}

CALCULATETABLE (
    ALL(  table[field] ),
    table[field2] = "Yes"
)

^{So this statement returns the unique value of the table[filed] column, and the following table[filed2]="Yes" does not play a filtering role for the previous statement, because the ALL function ignores all filters}

ALL – DAX Guide

^{Best Regards,}

^{Gallen Luo}

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