Different result CALCULATE and FILTER

[jdusek92]

Hello,

I am trying to achieve a "countif" column in a table, that will count the occurrences of rows ID in the whole table.

I tried these approaches:

FILTER = COUNTROWS(FILTER('Table','Table'[ID]=EARLIEST('Table'[ID])))

• this works

CALCULATE = CALCULATE(COUNTROWS('Table'),'Table'[ID] = EARLIEST('Table'[ID]))

• this does not calculate correctly

 I am wondering why CALCULATE is not working for this scenario. Could anybody explain, please?

Warm regards

Jakub

[Greg_Deckler]

@jdusek92 @Anonymous is generally correct. The Excel equivalent functions can be found here, including COUNTIF:

Excel to DAX Translation - Microsoft Power BI Community

[Anonymous · Accepted solution]

EARLIEST should be ditched. It's not recommended to use this function anymore. Use variables instead. CALCULATE does context transition (puts filters on all the rows) so it can't work here without extra directives. But at any rate, you should not use CALCULATE in calculated columns, especially in fact tables. Context transition is costly and will put the engine to a halt.