Forum Discussion

Rustami4's avatar
Rustami4
Icon for Helper II rankHelper II
8 years ago

Filter measure

Guys, tell me please how does the formula for FILTER look? Can't understand how it works. I need to filter the count of the definite indicator from the column. 
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Rustami4,

 

Could you please post a sample of you data in TEXT mode? An example is an easy way to understand how Filter will work. Usually, Filter will work with Calculate that is used to change the evaluation context of a formula. 

 

For example, this measure is quite sample. It will return the number of 'Product'[Color].

Measure =
COUNT ( 'Product'[Color] )

But this formula will return the number of red of 'Product'[Color] only.

MeasureWithFilter =
CALCULATE (
    COUNT ( 'Product'[Color] ),
    FILTER ( 'Product', 'Product'[Color] = "Red" )
)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale