Forum Discussion

anandav's avatar
anandav
Skilled Sharer
5 years ago

How to display a DAX variable table in Power BI Table visual

Hi All, I am using DAX variables in a measure to: - Create temperary CALCULATEDTABLE bases on user slicer selections - Use set functions to derive a resulting table   The requirement is to be ab...
Need Help
PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi anandav 

 

Download sample PBIX file

 

Create a new table and display in a visual

 

NewTable = 

    var AllNumbers = {1,2,3,4,5}
    var OddNumbers = {1,3,5}
    var EvenNumbers = EXCEPT(AllNumbers, OddNumbers)

RETURN

    EvenNumbers

 

Regards

Phil

anandav's avatar
anandav
Skilled Sharer
5 years ago

Hi Phil,

Thanks for the reply.

But as I mentioned in question, this is dynamic table created in a measure based on user slicer selection.

Therefore it cannot be pre-created as new table.

  • hai_pbi's avatar
    hai_pbi
    Frequent Visitor
    4 years ago

    Hi anandav 

    Did you find a solution in the end ? 
    I'm trying to achieve exactly the same thing you're discribing in your post.
    Any help would be appreciated.

    Cheers !