Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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 filter all? I want a measure which is not reacting to any filter and always
count the total of distinct dates of a table.
Thank you very much in advance.
Best.
how about you create a separate date table and not keep any connection with the facttalble.
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
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 66 | |
| 46 | |
| 42 | |
| 26 | |
| 19 |
| User | Count |
|---|---|
| 193 | |
| 124 | |
| 101 | |
| 67 | |
| 49 |