Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |