Creating a new Table based on Values in Slicer

[Anonymous]

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

[v-xuding-msft · Accepted solution]

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.

[amitchandak]

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.
Thanks