Forum Discussion
Krijgersss
Helper II
Helper IIdistinctcount with a related filter function
Hello i need some help i want to make a formule for distinctcount with a related function because i need to filter my distinctcount from a related table (see screenshot)
Hello Krijgersss ,
The easiest way is maybe to modify your relationship to allow filtering in both direction ?
becareful, it can alter your model functionnality or performances.
If only your disctinctcount need this filter, you can use a DAX Crossfilter function to modify your relationship in a specific measure.
KrijgersssHelper II
Helper IIi tried using crossfilter but this gives me extreem loeding times and wrong values is also tried using it in my measure but that also doesnt work. it's because of the model is build i need to distinctcountnoblank on a dimension table and a filter from a fact table