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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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

pranit828
Community Champion
Community Champion

HI @shei7141 

 

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





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

October NL Carousel

Fabric Community Update - October 2024

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