What is the correct parameter type for ALL?

[nemo]

I created this measure to test how context evaluation worked:

Last Non-blank =

LASTNONBLANK (

'Date'[Date],

CALCULATE ( COUNTROWS ( Sales ), ALL ( Product ) )

)

However, I got an error message saying that Product was not the correct parameter type (please see the screen shot).

Could someone please explain the meaning of that error message?

[PoojaDarbhe]

Hi @nemo ,

Please check whether you have relationship between Sales and Product tables, if that exist then only it will work, if not please create a relationship first then try.

Best regards,

Pooja Darbhe

[nemo]

Thanks @PoojaDarbhe for your quick response. The model did have a relationship between Product and Sales as shown below 

[PoojaDarbhe · Accepted solution]

Hi @nemo ,

Keep Product in single quotes 'Product'.

It is giving an error because Product is one of the built in function in Power BI.

Please try it and let me know if that works for you.

Best regards,

Pooja Darbhe

[nemo]

Excellent. Thanks @PoojaDarbhe. 

Intellisense seemed not that inteligent: it should have simply spelt out that Product was a reserved keyword 😉