Forum Discussion
Solved
Filter Condition
Multiple filter condition; 1) If I select 'Germany' it should return Profitsum value, if I select any other apart from 'Germany' it should return '0' 2) When I multiselect, along with Germany...
Hi,
Try this logic:Measure 11 = SWITCH(true(),max('Matrix example'[Brand])="Metal","result 1",ISFILTERED('Matrix example'[Brand])&&COUNTROWS(FILTER('Matrix example','Matrix example'[Brand]="Metal"))=1,"result 2","result 3")
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
Hi,
Try this logic:
Measure 11 = SWITCH(true(),max('Matrix example'[Brand])="Metal","result 1",
ISFILTERED('Matrix example'[Brand])&&
COUNTROWS(FILTER('Matrix example','Matrix example'[Brand]="Metal"))=1,"result 2","result 3")
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!