Forum Discussion

shei7141's avatar
shei7141
Icon for Helper III rankHelper III
6 years ago
Solved

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
Need Help
  • daxer-almighty's avatar
    daxer-almighty
    6 years ago
    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.

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI shei7141 

     

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

    • shei7141's avatar
      shei7141
      Icon for Helper III rankHelper III
      6 years ago

      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?

       

      • daxer-almighty's avatar
        daxer-almighty
        Icon for Solution Sage rankSolution Sage
        6 years ago
        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.
  • daxer-almighty's avatar
    daxer-almighty
    Icon for Solution Sage rankSolution Sage
    6 years ago
    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's avatar
      shei7141
      Icon for Helper III rankHelper III
      6 years ago

      thanks mate - I will give this a go now