crossjoin table not returning any measure

[shei7141]

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

[daxer-almighty]

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.

[shei7141]

thanks mate - I will give this a go now

[pranit828]

HI @shei7141 

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

[shei7141]

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?

[v-easonf-msft]

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

[daxer-almighty · 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.