Forum Discussion
Resourses Exceeded for Visuals
Am at a bit of a sticking point only have around 1 mil rows of data but getting rescources exceeding for visuals. I have tried to filter down my data as much as i can but i simply can't go any lower ...
Syk
Resident Rockstar
Resident RockstarIf Data is your table, every measure has to look at the entire table everytime it reevalutes. You can filter down your data first instead of using an if statement.
buy <1yr=
SUMX(
FILTER(Data, [Count] > 0 && [Count] < 12),
1
)