cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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.

namerequestedamount
Hardscape Products Limited45000
Hardscape Products Limited50000
H Butterfield25000
Speedclad 250000
Steve Benton Transport Limited50000
Steve Benton Transport Limited530000
Thermoseal Group Limited300000
Thermoseal Group Limited100000
Speedclad 1500000
Speedclad75000
Steve Benton Transport Limited50000

 

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Creating a new Table based on Values in Slicer

Hi @rsd1989 ,

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 )
    )

3.PNG

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.

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.

View solution in original post

2 REPLIES 2
Highlighted
Super User IV
Super User IV

Re: Creating a new Table based on Values in Slicer

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Community Support
Community Support

Re: Creating a new Table based on Values in Slicer

Hi @rsd1989 ,

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 )
    )

3.PNG

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.

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.

View solution in original post

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors