DistinctCount with Max Users in Particular field

Hi erikajain02,

 

New a calculated table:

Result output =
SUMMARIZE (
    FILTER (
        ADDCOLUMNS (
            Table,
            "Users", CALCULATE (
                COUNT ( Table[State Name] ),
                ALLEXCEPT ( Table, Table[Operator], Table[State Name] )
            ),
            "Max Users", CALCULATE (
                MAXX (
                    SUMMARIZE (
                        Table,
                        Table[Operator],
                        Table[State Name],
                        "Use", COUNT ( Table[State Name] )
                    ),
                    [Use]
                ),
                ALLEXCEPT ( Table, Table[Operator] )
            )
        ),
        [Users] = [Max Users]
    ),
    Table[Operator],
    Table[State Name]
)

 

Best regards,

Yuliana Gu