Distinct count measure when slicer from a disconnected table

[Richard_Halsall]

Hi,

I have a distinct count measure sitting in a card visual which counts the number of records showing in a matrix.

This works perfectly when sliced by filters based on related table fields, however I cannot get it to work when it is sliced by a filter with a value from a disconnected table.

The measure I use to show values in a matrix when the disconnected table filter is used is

Selected Flag =

VAR _a =

    SELECTCOLUMNS ( 'Technician Roles', "Slicer", [Technician Role] )

VAR _b =

    ADDCOLUMNS (

        _a,

        "Count",

            SWITCH (

                TRUE (),

                ISBLANK ( MAX ( 'DimContractor'[Job_Title__c] ) )

                    && [Slicer] = "No Certificate", 1,

                MAX ( 'DimContractor'[Job_Title__c] ) <> BLANK ()

                    && CONTAINSSTRING ( MAX ( 'DimContractor'[Job_Title__c] ), [Slicer] ), 1

            )

    )

RETURN

    IF (

        SUMX ( _b, [Count] )>=1

            || NOT ( ISFILTERED ( 'Technician Roles'[Technician Role] ) ),

        1,

        0

    )

I have tried and am not able to place this measure as a filter on the card visual

Can anybody provide help?

Thanks

[amitchandak]

@Richard_Halsall , the value has pass to one the column of table and connected table.

example

https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/

of like

calculate([Measure], filter(Table1, Table1[Column] in values(Table2[Column])  ))

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Richard_Halsall]

@amitchandak Hi, please find attached a sample pbix

I am trying to get the Technician Count Unique card to show the correct number of technicians in the matrix

If you select the filters ContractType or EmployeeDesc the Technician Count Unique is correct

If you select the filter Technician Role, individually or in conjunction with the other filters, the Technician Count Unique is incorrect

It is this filter which is driven by data in a disconnected table.

The disconnected table is also used in a measure, Selected Flag, to filter the matrix

Any help in getting the TechnicianCountUnique measure working would be appreciated.

https://we.tl/t-sdrZO73PEW