Can we add filter to an existing measure from Direct Query?

[Anonymous]

Hello.

Let's say I am connecting to a DirectQuery dataset, and it has a measure called "Total Sales". Can I create my own measure, and use the existing "Total Sales" measure, but using Calculate() and add additional filter, for example colour="red"?

Example below:

CALCULATE(
   [Total Sales],           // this is from a DirectQuery connection
   Table[Colour] = "Green"  // this is what I want to add
)

Does anyone know if this should work? I tried doing this, but my numbers doesn't change at all even after adding that colour filter.

[Ahmedx · Accepted solution]

pls try this

CALCULATE(
   [Total Sales],  
   FILTER(ALL('Table',Table[Colour] = "Green")  
)

[Ahmedx · Accepted solution]

pls try this

CALCULATE(
   [Total Sales],  
   FILTER(ALL('Table',Table[Colour] = "Green")  
)

[Anonymous · Accepted solution]

Thank you @Ahmedx . Apparently yours, and even the one in my example, works. It's just that the visual doesn't refresh properly after I changed the visual, so it looked like it didn't work, when in fact it did.

[Ahmedx]

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly