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
I have a question related to how ALL works when I pass in the Table vs when I pass in the Column. I understand it removes any filter applied to table or column. I noticed that If I use it with COUNTX and pass the column (COUNTX(ALL(columnA)), columnA) it would count only the distinct values (why?), and when I pass the table (COUNTX(ALL(tableA)), columnA) it would count all values. Is this behavior by design?
I do not understand how this relates to removing the filters.
TIA
Solved! Go to Solution.
A column reference always does a group by aggregation.
Kind regards,
Steve.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
A column reference always does a group by aggregation.
Kind regards,
Steve.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 14 | |
| 7 | |
| 4 | |
| 4 | |
| 3 |
| User | Count |
|---|---|
| 23 | |
| 10 | |
| 10 | |
| 6 | |
| 5 |