Forum Discussion
Sum only Values where another Column has Data
Anonymous Company won't allow file sharing, and the model is so large, I'm not even sure how to replicate it. I'll try with the Contoso database and see if I can replicate the issue. As I've explained, I think the problem may be that [GAGoal] is computed by a measure and not a column. And the [GAGoal] measure is computed by using other measures, which is like this:
[PreviousYearGrossAdds]/[PYGAsAll]*[LocQuota]
Did you see how it puts the grand total in each row instead of filtering it?
Hi BrianNeedsHelp ,
You can refer to my pbix file, I am also using the [GAGoal] measure instead of the columns, but it outputs correctly in my example file. Could you check your model relationships? In my sample pbix file the model relationship is unidirectional one-to-many.
Other than that, I think the incorrect measure results might be related to your hierarchy, could you create a table visual object and then place only [Date Column of Date Table], [GAGoal measure], [Gross Adds Column] and [SumGoals measure] and then observe the results.
To test this, create a new page and then only these three visual objects exist (slicer, card, table)
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous I took your pbix and replicated all of the measures to compute the Goals etc. I was able to make everything work in the pbix, only summing the values in the goal less than Max Gross Add Date. However, when I apply the same steps to my model, it simply won't work-it sums the whole total like in the picture I sent. Tried your suggestion with table and those fields and same result. Have no idea-it should work! Thanks for the suggestions.
Hi BrianNeedsHelp ,
Has your issue been resolved? If not, it may be difficult to troubleshoot if you can't provide a pbix file since measures are affected by many factors. Can you provide an example pbix file? (Only example data exists, not actual data)
Best Regards,
Neeko Tang
Anonymous I sent you a message yesterday that I was not able to replicate the issue in a PBIX file. It only doesn't work in the main model I use.