What is wrong with my filter?

[Anonymous]

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 · Accepted solution]

@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 data

Hope 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]

@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.