Distinct Count by Targets

Question

Hi everyone,&nbsp;I have a table with transactions, users, and transactions type...The idea is count the unique users by transactions type.....Someone can help me please?&nbsp;Table 1&nbsp;&nbsp;&nbsp;Table 2?Transaction IDUser IDTransaction Type&nbsp;Transaction TypeCount Unique User ID1U1A&nbsp;Only A12U2B&nbsp;Only B13U3A&nbsp;A and B24U1B&nbsp;&nbsp; &nbsp; &nbsp; Total45U2A&nbsp;&nbsp;&nbsp;6U4B&nbsp;&nbsp;&nbsp;&nbsp;Many thanksRui&nbsp;&nbsp;&nbsp;

camargos88 · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;Just create a calculated column to group the users and count them using distinct.&nbsp;&nbsp;&nbsp;Did I answer your question? Mark my post as a solution!Ricardo

Forum Discussion

Distinct Count by Targets

2 Replies

Related content

count distinct

Distinct Count

Distinct count

DAX Calculation for Distinct Count

Average - Distinct Count

Table 1			Table 2	?
Transaction ID	User ID	Transaction Type	Transaction Type	Count Unique User ID
1	U1	A	Only A	1
2	U2	B	Only B	1
3	U3	A	A and B	2
4	U1	B	Total	4
5	U2	A
6	U4	B