Forum Discussion

BrianNeedsHelp's avatar
BrianNeedsHelp
Resolver I
1 year ago

Sum only Values where another Column has Data

Harder than it looks:  I have this simple table like below:  I want to calculate how we're performing based on the goal in a Card.  So I need to Sum only the goal values where the Gross Adds column i...
CALCULATE
card
condition
sumx
Table
BrianNeedsHelp's avatar
BrianNeedsHelp
Resolver I
1 year ago

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.   

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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

  • BrianNeedsHelp's avatar
    BrianNeedsHelp
    Resolver I
    1 year ago

    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.