How to count user with REPORT transaction type only?

[kimchour]

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. 🙏

this user use 1 Transaction with REPORT transaction Type. I would like to include this user in the count.this user use different Transaction with REPORT transaction Type. I also would like to include this user in the count.this user use different Transaction but with different transaction Type. I do not want to include this user in the count.Table StructureRelationship

[Jihwan_Kim]

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"
    )
)

[kimchour]

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. 

i do not want to include this type of user in the count because they have both transaction type. I want to count only the user that have only REPORT type.

[Jihwan_Kim]

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"
    )
)

[kimchour]

hello @Jihwan_Kim please help me. 🙏

[Jihwan_Kim · Accepted solution]

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"
    )
)

[kimchour]

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