I'm following a training video explaining Table functions. I've created a Mesaure using a FILTER within a CALCULATE to calculate the amount of Sales per Category that come frorm orders of over 100:
To me, however, it seems easier to not use the FILTER command as CALCULATE alreay has a parameter which acts as a filter:
So - is there a good reason to use a FILTER command within a CALCULATE?
And if not, where else might FILTER be useful?
Solved! Go to Solution.