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 ?

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.

Follow this topic

Ghoushad Shafeeq

Last answered:

05 Sept 2021

Posted on:

05 Sept 2021

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

in Power BI / ALL

1 answers ( 0 marked as helpful)

Dimitar Shutev

Instructor

Posted on:

05 Sept 2021

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

Submit an answer

related questions