Forum Discussion
Value based on multiple filters
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?
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.
2 Replies
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"))
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.
