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
Hi all.
I'm trying to calculate a dynamic table with Dax, Based on an existing table with a slicer over it.
The new calculated table should contain only the values left by the slicer.
For example:
This is the original full table1:
choosing these values in slicer should populate a new table with these unique values only:
I don't want to use a visual's filter above the calculated table.
I want the Dax to directly calculate only the valid values.
Thanks
There are 2 types of tables; visual tables in a report and data tables in the model. You cannot use a slicer to influence the creation of a data table in a model.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 13 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 29 | |
| 24 | |
| 16 | |
| 11 | |
| 10 |