Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Umadhandapani
Helper II
Helper II

Filter Condition

Umadhandapani_1-1642746864553.png

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 and some other country, it shold sum the 'Profitsum' value + 0

 

1 ACCEPTED SOLUTION
ValtteriN
Super User
Super User

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")

ValtteriN_0-1642747999328.png

 

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!






Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
ValtteriN
Super User
Super User

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")

ValtteriN_0-1642747999328.png

 

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!






Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




amitchandak
Super User
Super User

@Umadhandapani , Try a new measure like

 

measure =
var _1 = countrows(allseleceted(Table[Country])
var _2 = countrows(filter(allseleceted(Table[Country]), Table[Country] = "Germany"))
return
Switch( tru(),
isblank(_2) , 0 ,
_2 =_1 = sum(Table[Profitsum])+0 ,
sum(Table[Profitsum])
)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.