Value based on multiple filters

[M_SBS_6]

Hi, 

I have a number field test_value that I need to see the values of based on some additional criteria below

Where test_ty in ("a","d") 

and test_yy = "ttt"

I don't want it to summarize though, any idea how to do this please? 

[Anonymous · Accepted solution]

Hi @M_SBS_6 ,

You could try to create a measure like

Measure = CALCULATE(SUM('Table'[test_value]),FILTER('Table',[test_ty] in {"a","d"}&&[test_tt]="ttt"))

Best Regards,

Stephen Tao

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

[amitchandak]

@M_SBS_6 , Just use them as slicers and add required field in viusal

or create a measure and add to visual

countrows(Table, [test_ty] in {"a","d"} && test_yy = "ttt"))