Forum Discussion
Resolver ISum only Values where another Column has Data
Super Userremember that in a table visual measures are calculated twice, once for the rows and once for the row total. You can choose "MAX" for the aggregation, or use HASONEVALUE / ISINSCOPE to modify the measure behavior according to where you are in the visual.
Resolver II simplified the measure, and now the sum total is correct for the whole month. But this isn't what I was wanting-Need to just add the numbers that are visible. I don't think this works for a measure? If you modify the PBIX to calculate GAGoal in a measure like [PreviousYearGrossAdds]/[PYGAsAll]*[LocQuota], you'Il see what I'm talking about. I've tried many different purmutations with all nearly the same result:
GoalLessthanDate = IF([Gross Adds]<>Blank(),( [PYGA]/[PYALLGAs])*[LocQuota1])I even used the exact same code that works here: Why Power BI totals might seem inaccurate - SQLBI But they must be calculating on columns and not measures? There would have to be a different approach to make this work. Please help.
- lbendlin
If you modify the PBIX to calculate GAGoal in a measure like [PreviousYearGrossAdds]/[PYGAsAll]*[LocQuota], you'Il see what I'm talking aboutVery much not recommended. Especially for troubleshooting you don't want to nest measures. Write your business logic out verbatim. Only reference measures if you are confident about the result and are willing to absorb the cost of the extra context transitions.