Forum Discussion

arvindarvind24's avatar
arvindarvind24
Icon for Helper II rankHelper II
3 years ago

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) Tr...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.