Top 5 Visitor browser - Problem with COUNTX function

[Anonymous]

Hi,

the function worked to count the URLs but now I want to do the same with the browsers and it gives me error, but I don´t know why.

What is the problem?

Thx

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

EARLIER is a DAX function that acts exclusively on row context,  and its purpose is to create a reference to a column value on an outer loop of the evaluation of the expression.  It is commonly used in calculated columns during nested row by row iterations. 

And it also can be used in measure when there nested row context in measure like ADDCOLUMNS function. For more details, please refer to https://javierguillen.wordpress.com/2012/02/06/can-earlier-be-used-in-dax-measures/

And in your situation, are you creating a  measure? Would you please try to use MAX() instead of EARLIER? If it doesn't work, please show us some sample data by onedrive for business that we can help you well.

If this post help, please consider accept it as the solution to help others find it more  quickly.

Best Regard,

Dedmon Dai