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!!👍
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
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!!👍