Forum Discussion
Helper IVDistinct count measure when slicer from a disconnected table
Super UserRichard_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.
Helper IVamitchandak 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.