Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |