Forum Discussion
Helper IICorrect DAX and Measure for % completed by State?
Before anything else, try making the directon between your two tables completed and population Both instead of one direction.
Community ChampionCan you provide some data, and what your measures are? For example one of your variables uses [count per state] but i don't know what that measure is, and I suspect that is part of the problem.
And you said Table1 and Table2 had some data, but your model doesn't show a Table1 or Table2.
If you could share your PBIX via OneDrive or DropBox that would be immensly helpful. Otherwise we will need to spend time typing in data just to get to where you are.
Helper IIHi, 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
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.