Show distinct dates from facttable using filter (all)

Question

Hello,for instance I have a Facttable with dates not being distinct.To count dates distincinctively I can use Distinctcount ( Table[Dates])&nbsp;Is there a ways to count distinct via Countx and filter all? I want a measure which is not reacting to any filter and always&nbsp;count the total of distinct dates of a table.&nbsp;Thank you very much in advance.&nbsp;Best.&nbsp;

anonymous · Answer

&nbsp;Hi,Once you create a measure you can edit interactions and stop any interaction with the measure.In that way it will not get affected by any filter.&nbsp;Thanks

applicable88 · Answer

Hi&nbsp;Anonymous&nbsp;,I understand what you mean. But thats on the level of visualization.&nbsp;I for myself have another purpose in mind. A measure which always display All distinct, and can be use as a measure inside other measures. The edit interaction is rather for visualization not reacting on filter selection.&nbsp;&nbsp;Best.&nbsp;

anonymous · Answer

how about you create a separate date table and not keep any connection with the facttalble.&nbsp;

Forum Discussion

Show distinct dates from facttable using filter (all)

3 Replies

Related content

Recover a field from facttable in another facttable

Recuperar un campo de facttable en otra facttable

count distinct

Distinct Count with filter

Help with Filter + Distinct