Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Hi,
Try this logic:
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!
Proud to be a Super User!
Hi,
Try this logic:
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!
Proud to be a 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])
)
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |