Forum Discussion

frank_gerritsma's avatar
frank_gerritsma
New Member
3 years ago

Measures not efficient

hi,   I use two measures (below). Table 1_log_activiteit contains 600K rows. Is there a way to make the measures more efficient? Currently the desktop application stalls when I use them in a tab...
Need Help
ppm1's avatar
ppm1
Solution Sage
3 years ago

It is not good practice to filter an entire table in your CALCULATE (best to do only one column at a time). It is also not good to add +0. See this article How to return 0 instead of BLANK in DAX - SQLBI, and try this measure instead.

correctie_door_adviseur =
CALCULATE (
    COUNTROWS ( '1_log_activiteit' ),
    '1_log_activiteit'[activiteit] = 15
)

Pat