Forum Discussion

CAVCX's avatar
CAVCX
Frequent Visitor
3 years ago
Solved

Problem consolidating across tables

Hello,   I have two tables in a form as below.   TABLE A - HAS A SINGLE ROW FOR EACH ACCOUNT ID/CUSTOMER NAME       TABLE B - SHOWS PROJECTS MADE BY ANY ACCOUNT WITH EACH ROW BEING A DI...
Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, CAVCX 

     

    You can try the following methods.

    Total_Projects = CALCULATE(COUNT('Table B'[Account ID]),FILTER('Table B',[Account ID]=EARLIER('Table A'[Account ID])))
    Video_Project = CALCULATE(SUM('Table B'[Video]),FILTER('Table B',[Account ID]=EARLIER('Table A'[Account ID])))

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, CAVCX 

 

You can try the following methods.

Total_Projects = CALCULATE(COUNT('Table B'[Account ID]),FILTER('Table B',[Account ID]=EARLIER('Table A'[Account ID])))
Video_Project = CALCULATE(SUM('Table B'[Video]),FILTER('Table B',[Account ID]=EARLIER('Table A'[Account ID])))

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

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

CAVCX's avatar
CAVCX
Frequent Visitor
3 years ago

Thanks the solution worked!

 

I realised I need one filter on the data. Do you think you can help with that too?

 

If I want to make an additional Column, in which I can EXCLUDE a particular Project Name (4th Column of Table B) in the Count, then is there a way to do it? E.g. I want to total the projects which have value of 1, except those which are named "Test"

 

Thanks,

Regards