Forum Discussion

zaza's avatar
zaza
Icon for Resolver III rankResolver III
5 years ago

Optimizing DAX Measure

I have the following measure whihc works perfectly. However my dataset grew from 2 million rows to 42 million rows and Now this measure takes way too much to load, sometimes some visuals where this i...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

zaza , looking at your formula, there are only two things I can think of as of now.

1. if , You can get the second table from the first Table.

2. On the First table, use addcolumns and add the other two columns using all except