Forum Discussion
Count from Related
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
2 Replies
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=czNHt7UXIe8Hi 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 _1Measure 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.
