Forum Discussion
Measure total wrong
Hello I created a measure where total is coming wrong. I tried options shown in other posts with has one filter, not working. Any help? My measure looks like Calculate(datediff(firstdate(table1[fie...
- Yes,its measure total problem. When I added if( hasonefilter (table1[field1) at the front of created measure, total row goes away. For now I am okwith that
Thanks, it was my typo. My measure is working perfectly for each row. it’s just the total at bottom of table visual that is not showing right value. So I tried to add a part with Dax ,’has one filter’, But am not able to get the total row still right.
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
- Yes,its measure total problem. When I added if( hasonefilter (table1[field1) at the front of created measure, total row goes away. For now I am okwith that