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.

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

Hi, thank you for looking at the post..  The link below will allow you to download the data file and the .pbix file.

 

I mention Table 1 and Table 2 but they are named differently in the model (sorry).

 

Completed1 = Data showing what has been Completed (related by ESN)

Population = Data showing total population (related by ESN) 

 

https://app.box.com/s/w5x5utwdscw4efm6uxfkc5ewn2b0c3ut

 

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

Took a crack at this. No idea if the numbers are correct. PBIX is attached. Basically, changed the relationship as suggested earlier. Messed with the % Complete calc.