Filtered sum

[Syndicate_Admin]

Hello

I need to add the values of the column ("Inscrits") of the table ("Annexa2")

But segun un filtro: tabla "Fam_Act", column "Type" = "Workshops"

---------

Table "Annexa2" and "Fam_Act" are related through the "Fami_Act_Centre2" field

Thanks a lot!!

[amitchandak · Accepted solution]

@Syndicate_Admin ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[v-rzhou-msft · Accepted solution]

Hi @Syndicate_Admin ,

I think you want to calculate sum by Fami_Act_Centre2 and Type in "Fam_Act" table should equal to Workshops. 

Try this code.

Column = sumx(filter(Annexa2,Annexa2[Fami_Act_Centre2]=EARLIER(Fam_Act[Fami_Act_Centre2])&& Fam_Act[Type] ="Workshops" ) ,Annexa2[Registered] )

Result is as below.

Best Regards,
Rico Zhou

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

[Syndicate_Admin]

Thanks a lot!!

[v-rzhou-msft · Accepted solution]

Hi @Syndicate_Admin ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file without sensitive data.

Best Regards,

Rico Zhou

[Syndicate_Admin]

Excuse me... that I have not explained myself very well

I want to add the column "inscrits" of the first table, but only take into account the rows that in the related table "Fam_Act" put "Workshops"

Table "Annexa2"

Column 1	Fami_Act_Centre2	Registered
	AAA	3
	BBB	4

"Fam_Act" table

Type	Fami_Act_Centre2
Workshops	AAA
Diffusion	BBB

[v-rzhou-msft · Accepted solution]

Hi @Syndicate_Admin ,

I think you want to calculate sum by Fami_Act_Centre2 and Type in "Fam_Act" table should equal to Workshops. 

Try this code.

Column = sumx(filter(Annexa2,Annexa2[Fami_Act_Centre2]=EARLIER(Fam_Act[Fami_Act_Centre2])&& Fam_Act[Type] ="Workshops" ) ,Annexa2[Registered] )

Result is as below.

Best Regards,
Rico Zhou

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

[amitchandak]

@Syndicate_Admin a, new column in table 1

maxx(filter(Fam_Act, Fam_Act[Fami_Act_Centre2] = Annexa2[Fami_Act_Centre2] ) ,Fam_Act[Type] )

or

maxx(filter(Fam_Act, Fam_Act[Fami_Act_Centre2] = Annexa2[Fami_Act_Centre2] && Fam_Act[Type] ="Workshops" ) ,Fam_Act[Type] )

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

[amitchandak · Accepted solution]

@Syndicate_Admin ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.