topic Re: How to count user with REPORT transaction type only? in DAX Commands and Tips

How to count user with REPORT transaction type only?

kimchour — Wed, 28 Feb 2024 03:20:02 GMT

Dear all,

I would like to have a card counting how many user with REPORT transaction type only. I have screenshot to explain the scenarios. I would really appreciate for u taking your time to help me. Thank you in advance. 🙏

Re: How to count user with REPORT transaction type only?

Jihwan_Kim — Wed, 28 Feb 2024 03:43:54 GMT

Hi,

Please try something like below whether it suits your requirement.

users count expected result: = COUNTROWS ( FILTER ( SUMMARIZE ( 'User with daily transaction', 'User'[Personnel Number], 'Transaction'[Transaction Type] ), 'Transaction'[Transaction Type] = "Report" ) )

Re: How to count user with REPORT transaction type only?

kimchour — Wed, 28 Feb 2024 04:01:26 GMT

Dear Jihwan,

Thank you for your help. However, it is not really what i want because it include the user that have both REPORT and TRANSACTIONAL transaction type. and I want to count the user that have only REPORT type.

Re: How to count user with REPORT transaction type only?

Jihwan_Kim — Wed, 28 Feb 2024 04:12:11 GMT

Hi,

thank you for your message, and please try something like below, or, please share your sample pbix file and then I can try to look into it. thank you.

users count expected result: = COUNTROWS ( FILTER ( SUMMARIZE ( 'User with daily transaction', 'User'[Personnel Number], 'Transaction'[Transaction Type] ), CALCULATE ( COUNTROWS ( VALUES ( ['Transaction'[Transaction Type] ) ) ) = 1 && 'Transaction'[Transaction Type] = "Report" ) )

Re: How to count user with REPORT transaction type only?

kimchour — Thu, 29 Feb 2024 07:06:48 GMT

hello Jihwan_Kim please help me. 🙏

Re: How to count user with REPORT transaction type only?

Jihwan_Kim — Thu, 29 Feb 2024 07:37:53 GMT

Hi,

Please try something like below whether it suits your requirement.

users count expected result = COUNTROWS ( FILTER ( SUMMARIZE ( 'User with daily transaction', User[Personnel Number], 'Transaction'[Transaction Type] ), CALCULATE ( COUNTROWS ( CALCULATETABLE ( SUMMARIZE ( 'User with daily transaction', 'Transaction'[Transaction Type] ), ALL ( 'Transaction'[Transaction Type] ) ) ) ) = 1 && 'Transaction'[Transaction Type] = "Report" ) )

Re: How to count user with REPORT transaction type only?

kimchour — Thu, 29 Feb 2024 10:10:48 GMT

Jihwan_Kim IT WORKS. Thank you so much. 😍🙏🙏