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
Pbiuserr
Post Prodigy
Post Prodigy

INTERSECT with tables having different amount of columns

Hello, 
I have two tables - dimension and fact. Dim has 10 columns, Fact 28

All I want is to INTERSECT their id's. How can I do that? Tried with FIRSTNONBLANK, VALUES, DISTINCT I keep having " A table of multiple values was supplied where a single value was expected" 

How to handle that?

1 ACCEPTED SOLUTION
FreemanZ
Super User
Super User

hi @Pbiuserr 

INTERSECT returns a table, if you are creating a measure try like:

Measure = COUNTROWS(INTERSECT())

or

Measure =

CONCATENATEX(

   INTERSECT(),

   DimTable([ID]),

   ", "

)

 

View solution in original post

2 REPLIES 2
FreemanZ
Super User
Super User

hi @Pbiuserr 

INTERSECT returns a table, if you are creating a measure try like:

Measure = COUNTROWS(INTERSECT())

or

Measure =

CONCATENATEX(

   INTERSECT(),

   DimTable([ID]),

   ", "

)

 

I still got output that "Each table argument of 'INTERSECT' must have the same number of columns.". Can you help me on that?

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.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.