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...
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.
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.
    • v-easonf-msft's avatar
      v-easonf-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      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