Forum Discussion

bijuphilipose's avatar
bijuphilipose
Frequent Visitor
5 years ago

Help with a measure

Hi All,   Need help in creating a DAX. I have three tables. Date, Table A, Table B.   We need to find out the subscriber who has left from two table. Now we count the subsciber id if the close da...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

bijuphilipose , You need to have a common subscribe table , with that you can run a formula like

refer: https://www.youtube.com/watch?v=Bkf35Roman8

 

countx(filter(summarize(Suscriber, Suscriber[Suscriber], "_1", Count(Table1[Close Date])+0, "_2", Count(Table2[Close Date])+0), _1 >0 && _2>0),[Suscriber])

bijuphilipose's avatar
bijuphilipose
Frequent Visitor
5 years ago

Thanks for reply!

 

IN my case I only want the id from Table A and there close dates from A or B. The table B can have more ID in there (a common table does not works). Now, I need to check any ID in Table A has a close date in A or B. My date table is linked to closed date of Table A.