Skip to main content
cancel
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

Reply
anandav
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:

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

 

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

 

 

 

3 REPLIES 3
PhilipTreacy
Super User
Super User

Hi @anandav 

 

Download sample PBIX file

 

Create a new table and display in a visual

newtab3.png

 

NewTable = 

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

RETURN

    EvenNumbers

 

vals3.png

Regards

Phil



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

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

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