Forum Discussion
Solved
Order of FILTER function
Good day, I'm looking for some DAX help. Edit: added sample My model looks like: Customer *→1 Bridge 1←* Actions Product *→1 So note the facts (actions) are connected...
Please try:
Filter combination = VAR _filter1 = [Filter 1] var _filter2 = [Filter 2] return IF(ISBLANK(_filter2),_filter1,_filter2)
So to be clear. The expected result:
| Bridge (after filter) | |||||
| ActionKey | Max | Price measure | 1←* | ActionKey | Price |
| 50000-16 | 16 | 5 | 50000-16 | 5 | |
| 50153-6 | 6 | 10 | 50153-6 | 10 | |
| 100028-16 | 16 | 20 | 50000-6 | 15 | |
| 100028-16 | 20 |