SUMIF Measure in Reports Page

[ddonovan]

Hello, I have a sumif/calculate function I am trying to build in one of my reports as a measure. I have a table called 'Investment Firms' in which I want to sum a 'Score' field from a table called 'Call Logs' connected by a unique ID.  I read some other posts and came up with the below formula.  The data is coming out as blank. Can anyone help me find what I am doing wrong?

Calculate( SUM( 'Call Log'[Score]), FILTER( 'Call Log', 'Call Log'[Company__c] = [ID]))

I have the identical formula in the 'Investment Firm' Data table and it works. I need to have it as a measure in the report so it adjusts accordingly to the report filters.

Thank you

[amitchandak]

Not sure from where the ID column is there in the formula. Can put some examples in term of values. Also, see if SUMX can work for you.

[ddonovan]

@amitchandak  This is for a table visualization connected to my 'Investment Firm' dataset. Each record has a 18 digits unique ID with the column label 'Id'. So the [Id] reference is to that unique Id. That same 18 digit Id is in my 'Call Log' dataset with the column label 'Company__c'. So that is where the filter for 'Call Log'[Company__c] = [Id] comes in. I also just tried the SUMX function and that had the same result.

The 'Id' to 'Company__c' relationship is one to many.

Examples of Id/Company__c values:

0010d00001KGLHmAAP
0010d00001QUa8pAAD
0010d00001KlqWqAAJ

[dax]

Hi ddonovan,

I test this in my environment, which should work. In addition, you need to make sure whether the id and company_c 's result is same. Did you create relationship between two tables based on id and compayn_c? If possible, could you please inform me more detailed information(such as your sample, and your current design). Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.