Forum Discussion
What is wrong with my filter?
I want that only data from china is shown. I need this in calculation. TrackET [Country] is in my dataset but why is it grey?
Thank you for your time
Anonymous you need to use calculate function for this to work effectively
Measure = calculate(TOTALYTD(sum(Orders[Sales]),Orders[Order Date],Orders[Product Category]="Furniture"))
Replace the bold column names with respect to your dataHope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos, Press the thumbs up button!!👍
2 Replies
Anonymous you need to use calculate function for this to work effectively
Measure = calculate(TOTALYTD(sum(Orders[Sales]),Orders[Order Date],Orders[Product Category]="Furniture"))
Replace the bold column names with respect to your dataHope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos, Press the thumbs up button!!👍- amitchandak
Super User
Anonymous , Filter is outside totalytd, It should after "9/30" before ")"
or add "calculate(" at start and ")" at the end
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
