Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Including Blank/Null Values in Slicer/Filter

Hello,   I have 2 tables in my data model: Employess and Projects that has a 1 to many relationship. I was wondering if there is a way to filter null values in my model(ie. the relationship in my d...
Need Help
Duia's avatar
Duia
Resolver II
4 years ago

Hi  Anonymous ,

Here are the steps you can follow：

1. Create measure.

Flag =
var _select=SELECTEDVALUE('Projects Table'[Project Category])
var _123=
SELECTCOLUMNS(
FILTER('Projects Table','Projects Table'[Project Category] = _select),"1",'Projects Table'[Employee ID])
return
IF(
    MAX('Employees Table'[Employee ID]) in _123,1,0)

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly