Forum Discussion
Measure returns wrong result
Hello everyone, Here is the link to my sample data. Please note in the "Data" table, each Part Number corresponds to a COE Description and there are a total of 5 COE Descriptions. Table "...
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
Hi Greg_Deckler , thanks for your response. I tried your measures but it didn't seem to work on mine.
The measure still returned 14 instead of 7.
Here is the link to my sample pbi. Can you please take a look at it? Thanks a lot!