Count from Related

[arvindarvind24]

Hi,

  Need your help on to get count from other table as mentioned in below output.

code	Total Enrolled	Enrolled in store(Count)	Enrolled in store	Transacting in other store(Count)	Transacting in other store	enrolled in other store & Transacting in this store(Count)	enrolled in other store & Transacting in this store
14	2	1	1000	1	3000	1	2000
1054	1			1	2000
Total	3	1	1000	2	5000	1	2000

https://drive.google.com/file/d/1FIowMcs7APghvtnyzwypLgVwN1dA3ta6/view?usp=sharing 

@amitchauhan @bvanderwatt @ray_ux @tamerj1 @SpartaBI @v-chenyue-msft  @mangaus1111 

[Anonymous]

Hi @arvindarvind24 ,

Please have a try.

Create measures.

Measure = var _1=IF((MAX(Sales[admsite_code]) in VALUES(Customer[admsite_code])),1,0)
var _2=
IF(_1=1,MAX(Customer[mobile]),BLANK())
return
_1

Measure 2 = SUMX(FILTER(ALL(Sales),Sales[admsite_code]=SELECTEDVALUE(Sales[admsite_code])&&MAX(Sales[admsite_code]) in VALUES(Customer[admsite_code])),MAX(Sales[netamt]))

If it still does not help, please provide more details with your desired output.

Best Regards

Community Support Team _ Polly

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

[amitchandak]

@arvindarvind24 , refer 4 ways to copy data from one table to another, if those can help
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8