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.
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