Forum Discussion

Applicable88's avatar
Applicable88
Icon for Impactful Individual rankImpactful Individual
3 years ago

Show distinct dates from facttable using filter (all)

Hello, for instance I have a Facttable with dates not being distinct. To count dates distincinctively I can use Distinctcount ( Table[Dates])   Is there a ways to count distinct via Countx and fi...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

 

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.

 

Thanks

  • Applicable88's avatar
    Applicable88
    Icon for Impactful Individual rankImpactful Individual
    3 years ago

    Hi Anonymous ,

    I understand what you mean. But thats on the level of visualization.

     

    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. 

     

    Best.