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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
shei7141
Helper III
Helper III

crossjoin table not returning any measure

Hi all,

 

This might be really simple for most of you. I am have the following dax formula to to join two tables:

 

DatabaseForMonthlyRevised = FILTER(CROSSJOIN(DatabaseTab,'Calendar'),'Calendar'[Date]>=DatabaseTab[StartDateRevised]&&'Calendar'[Date]<=DatabaseTab[EndDateRevised])
 
This works likes a charm, but it does not bring any of the measures from "DatabaseTab" table.
What can I modify to include the measures in the returning Table?
 
Thanks heaps,
Shei
1 ACCEPTED SOLUTION

It's not a problem of where the measure is hosted but a problem with the measure itself. To a measure it doesn't really matter where it's stored.

View solution in original post

6 REPLIES 6
daxer-almighty
Solution Sage
Solution Sage

If you want to change the hosting table for a measure... then you either do it manually one by one using the ribbon or you can do it all in one go using Tabular Editor.

thanks mate - I will give this a go now

Anonymous
Not applicable

HI @shei7141 

 

You have to create your required measure after crossjoining in the new crossjoined table not before it.

thanks heaps mate

 

the measure is now create but when I am trying to plot it on a simple line graph no values are shown?

 

Hi, @shei7141 

It seems that you have solved this problem.

If so ,please  mark the helpful reply as  solution to close this thread.Other community members will easily find the solution when they get the same issue.If still need help in measure,please feel free to ask. Thanks a lot!

 

Best Regards,
Community Support Team _ Eason

It's not a problem of where the measure is hosted but a problem with the measure itself. To a measure it doesn't really matter where it's stored.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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