Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

DAX | Can not create a table from selected value as dynamic method.

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 cr...
  • jpessoa8's avatar
    jpessoa8
    2 years ago

    Hello Anonymous  , 

    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

jpessoa8's avatar
jpessoa8
Continued Contributor
2 years ago

Hello Anonymous  , 

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