Forum Discussion
DAX Measure not adding up
Hi Experts Cannot see the error in my DAX Measure (the table below clearly shows the Sum of No and Yes as 130 but the total is 113) everything is in one master FACT table....meseaure below ...
worked it out
ActivityCount_ =sumx(SUMMARIZE(act_rates_activity_volume_and_cf_days,act_rates_activity_volume_and_cf_days[activity_type_1],act_rates_activity_volume_and_cf_days[MCCP Flag]),[ActivityCountTest_])
Anonymous 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 Tried it and no luck>>>>