There are many blogs on COUNTD with blending (One is mine as well COUNTd in secondary DS Tableau )
Please check the above links and see if anyone of the same matches your's case
Please see attached workbook and screenshot examples below. I chose not to use Data Blending but to JOIN your two data sources together in the Data Source Window. The reason is due to the first screenshot error below. We cannot use ATTR if trying to create an LOD type calculation if blending data sources. As it turns out, I didn't actually end up using an LOD, but thought I might have to, hence the reason for JOINING the data together as shown in the second screenshot (followed by examples). If this helps resolve your issue, please mark this response as correct. Thx, Don
P.S. - I also added a secondary workbook, which keeps your original method of Data Blending and achieves same results. V.2 D
Join of both data sources together:
Produces the results you're looking for:
Thanks for your response.Im unable to open workbooks attached as i use 10.4 version Tableau. Could you please downgrade the workbooks and send again.
In real time project i cannot do data blending because both the sources are Tableau server data source. Only option is data blending. I would like to see your workbook where you have used blending and got required output.