Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello there,
I want to create a custom table as shown below, but I can't get the value I filtered from the table using "selectedvalue." "SELECTEDVALUE" works in a measure, but I can't use it when creating a column or table, and it returns a blank value. How can I handle this?
Thanks for your help.
Table =
VAR A=
CALCULATE(MIN('odscs vw_cs_master'[company_id]),FILTER('odscs vw_cs_master','odscs vw_cs_master'[company_id]=SELECTEDVALUE('odscs vw_cs_master'[company_id])))
RETURN
CALCULATETABLE(
'odscs vw_cs_master',
'odscs vw_cs_master'[company_id]=A
)
Solved! Go to Solution.
Hello @ysfkymz ,
Tables and Calculated Tables are only generated on refresh time.
For that reason, they can never "catch" the value of a selection from a visual, slicer, filter, etc. even with the usage of formulas like SELECTEDVALUE().
You can see more information in the Microsoft Learn : Create calculated tables in Power BI Desktop .
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution or giving it a kudos
Thanks!
You can also check out my LinkedIn!
Best regards,
Jorge Pessoa
Hello @ysfkymz ,
Tables and Calculated Tables are only generated on refresh time.
For that reason, they can never "catch" the value of a selection from a visual, slicer, filter, etc. even with the usage of formulas like SELECTEDVALUE().
You can see more information in the Microsoft Learn : Create calculated tables in Power BI Desktop .
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution or giving it a kudos
Thanks!
You can also check out my LinkedIn!
Best regards,
Jorge Pessoa
User | Count |
---|---|
21 | |
19 | |
12 | |
10 | |
9 |
User | Count |
---|---|
30 | |
25 | |
15 | |
13 | |
10 |