Forum Discussion

efowler's avatar
efowler
Icon for Helper II rankHelper II
6 years ago
Solved

Correct DAX and Measure for % completed by State?

Hi,   I do not have my measure or DAX (or both) setup correct.  I searched and could not find any solutions.   Can you review and provide guidance on this?    Data Info.    Table 1 = Total Popul...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Before anything else, try making the directon between your two tables completed and population Both instead of one direction.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Before anything else, try making the directon between your two tables completed and population Both instead of one direction.

efowler's avatar
efowler
Icon for Helper II rankHelper II
6 years ago

Got it thank you!   Change the relationship cross filter to BOTH and rewrote the measure and it worked perfect..    Thank you!

 

Now I need to do some research on what exactly that does so I can understand it for the future..