Last answered:

05 Sept 2021

Posted on:

05 Sept 2021

0

CountRows and ALL Function difference !!!!!!!!!!

Please explain the difference between COUNTROWS ad ALL Function as they can find the total Sales for all rows.

ALL FUnction returns the rows without the filters applied. Is that the only difference ?

1 answers ( 0 marked as helpful)
Instructor
Posted on:

05 Sept 2021

0

COUNTROWS is an aggregation function whilst ALL is filter modifier. You cannot say ALL without including inside CALCULATE or SUMX, etc. They are two different functions. You cannot say ALL(TableName) and expect to see the same results as COUNTROWS because it will return an error. ALL ignores any filters applied on the table/column specified inside.

Submit an answer