counting by joining tables

Hi kasife ,

In this select you do not have any name so you cannot make a count based on the name.

When you refer that the tables are related based on broker do you have a separate that identifies each broker and is ID?

If yes you could try something similar to this:

Count Brokers =
VAR _selectedBroker =
    DISTINCT (
        UNION (
            SELECTCOLUMNS ( _leads, "Broker", [idcorretor] ),
            SELECTCOLUMNS ( _pastas, "B", [idcorretor] ),
            SELECTCOLUMNS ( _ccvs, "B", [idcorretor] ),
            SELECTCOLUMNS ( _repasses, "B", [idcorretor] )
        )
    )
VAR _brokerstable =
    FILTER ( BrokersTable, BrokersTable[idcorretor] IN _selectedBroker )
RETURN
    COUNTROWS ( DISTINCT ( SELECTCOLUMNS ( _brokerstable, [name] ) ) )