Forum Discussion
Total Hours Total not working as expected
Community ChampionGartski83 Two ways to potentially solve the issue. One, you could potentially make your relationship between Int Targets and Int Resources have a direction of Both. The second solution would be to use LOOKUPVALUE or MAXX(FILTER(...),...) to lookup your KPI Target in Int Resources.
Thanks for the response i was looking at your book on Amazon yesterday.
I have tried changing the direction to both with no joy 😞
I tried a measure for this as well which gives me the correct answer for a resource but the total appears to be way out
- Greg_Deckler
Gartski83 First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8Greg_Deckler I am afraid i could not work out how your links related to my problem as I say really new to DAX.
I tried to create a get around my totals by creating a measure where I did a SUM on the measure but it just ignores the calculation in the measure
I would settle for a visual outside the table for this figure
But with the correct vaule