Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Skilled Sharer
Skilled Sharer

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 able to display the resulting table. I cannot pre-load these as M query tables as these are caluclated based on user slicer selection.


In DAX Studio query I can do the following to return the rows of the resulting table:

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


How can I achieve the similar results in Power BI to diplay the results in a Table visual?




Super User
Super User

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)







Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Blog :: YouTube Channel :: Connect on Linkedin

Proud to be a Super User!

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.

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 !

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors