Forum Discussion
Resolver ISum only Values where another Column has Data
Hi BrianNeedsHelp ,
I want to acknowledge valuable input provided by lbendlin . Their initial ideas help guide my approach. However, I noticed that more details are needed to fully understand this issue.
We can create two measures.
Measure 2 = IF(SUM('Table'[Gross Adds ])<>BLANK(),[GAGoal],0)SumGoals = SUMX(FILTER(ALLSELECTED('Calendar'),[Date]<=MAX('Calendar'[Date])),[Measure 2])Then the result is as follows.
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
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.
Resolver IThis is what it does: [SumGoalslessThanDate] is like your Measure2.
Hi BrianNeedsHelp ,
Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?
Please provide me with your pbix file after removing sensitive data.Refer to:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards,
Neeko Tang
- BrianNeedsHelp
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.