Forum Discussion
Creating a new Table based on Values in Slicer
Hi, I will try and make this as simple as possible...
I have a dataset which is coming from SQL which contains a list of Individuals with multiple requested amounts. there is more than one requested amount to individual please see below.
| name | requestedamount |
| Hardscape Products Limited | 45000 |
| Hardscape Products Limited | 50000 |
| H Butterfield | 25000 |
| Speedclad | 250000 |
| Steve Benton Transport Limited | 50000 |
| Steve Benton Transport Limited | 530000 |
| Thermoseal Group Limited | 300000 |
| Thermoseal Group Limited | 100000 |
| Speedclad | 1500000 |
| Speedclad | 75000 |
| Steve Benton Transport Limited | 50000 |
I have a slicer on the Desktop to bring back the data for that one name
In a New calculated table i need to bring back all requested amount value based on the name which is selected in the slicer.
So basically as the name changes in the slicer i need the requested amount data in the table to change accordingly from ascending smallest to largest.
Thank you
Hi Anonymous ,
The calculated tables and calculated columns are static. So it is impossible to get data from a slicer dynamically. You could try to create a measure to show the selected values. Please see the formula below:
Measure = VAR a = ALLSELECTED ( 'Table 1'[name] ) RETURN CALCULATE ( SUM ( 'Table'[requestedamount] ), FILTER ( 'Table', 'Table'[name] IN a ) )Reference:
https://radacad.com/scenarios-of-using-calculated-tables-in-power-bi
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
The information you have provided is not making the problem clear to me. Can you please explain with an example. If possible please share a sample pbix file after removing sensitive information.
ThanksHi Anonymous ,
The calculated tables and calculated columns are static. So it is impossible to get data from a slicer dynamically. You could try to create a measure to show the selected values. Please see the formula below:
Measure = VAR a = ALLSELECTED ( 'Table 1'[name] ) RETURN CALCULATE ( SUM ( 'Table'[requestedamount] ), FILTER ( 'Table', 'Table'[name] IN a ) )Reference:
https://radacad.com/scenarios-of-using-calculated-tables-in-power-bi
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
