help with Dax to create a summary card based on rows distinct row count selected to a table

[Anonymous]

I need two Dax measures to:
1. Create a summary card "Total codes used by firm for all clients" to be the distinct count of column "Codes used by firm"
2. Create a summary card "Total number of codes used by all firms" to be the distinct count of column "potential codes that can be billed"

Rules:

The requirement is that the columns in table are distinct count of taskcodes used.   

The table  "report ProducerConsumerTaskCodes"  is a subset of "report ConsumerTaskCodes".

 Card "Total codes used by firm for all clients"  is from table "report ProducerConsumerTaskCodes"  

Card  "Total number of codes used by all firms"  is from table "report ConsumerTaskCodes".

 Card "Total codes used by firm for all clients"  is not expected to be equal to the sum of rows in "codes used by firm" because only unique codes aggregated.  

Also, 

Card "Total number of codes used by all firms" is not expected to be equal to the sum of rows in "Codes used by firm" because only unique codes are aggregated.     

PBIX:

https://1drv.ms/u/s!AlMdRxAveLesgcFjKD_Skl86sy5a4A?e=eUc4Jb

[v-xulin-mstf]

Hi @Anonymous

Sorry, I have no access to the link, please provide public link.

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[Anonymous]

@v-xulin-mstf    Here is the link: 

https://1drv.ms/u/s!AlMdRxAveLesgcFjKD_Skl86sy5a4A?e=eUc4Jb

Thanks.

[v-xulin-mstf]

Hi @Anonymous

Try measure as:

Total number of codes used by all firms = 
SUMX(VALUES('Consumer'[client   name]),[*Total ConsumerTask codes grouped])

Total codes used by firm for all clients = 
SUMX(VALUES('Consumer'[client   name]),[*Total producerConsumerTask codes grouped card])

 Is this your expected output?

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!