Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
I am wondering why CALCULATE is not working for this scenario. Could anybody explain, please?
Warm regards
Jakub
Solved! Go to 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.
@jdusek92 @Anonymous is generally correct. The Excel equivalent functions can be found here, including COUNTIF:
Excel to DAX Translation - Microsoft Power BI Community
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |