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)
KrijgersssHelper II
Helper IIi tried this but this gives me the same result it doesnt let the filter function work. it's the way the model is build i need to count from a dimension table and i need to filter from a fact tabel i tried using crossfilter but this gives me extreem loeding times and wrong values
tamerj1
Community Champion
Community ChampionPlease ignore my above solution. I have edited it by mistake and pasted a solution that was intended for another question in the forum.
I remember my original solution included summarizing the fact table by the dimension column. That should work unless there are more information that need to be provided. If you have an active one to many single direction relationship between the two tables, normally this should work.