Forum Discussion

stribor45's avatar
stribor45
Icon for Post Prodigy rankPost Prodigy
1 year ago
Solved

How to summarize virtual table table

I am trying to summarize this virtual table (non base table) and of course I am getting error that the base table is expected. Can someone assist please.   DEFINE VAR C = ADDCOLUMNS ( ...
  • tamerj1's avatar
    tamerj1
    1 year ago

    stribor45 

    Missed the @ sign 😅

    DEFINE
    VAR C =
        ADDCOLUMNS (
            DISTINCT ( UNION ( DISTINCT ( 'A'[ID] ), DISTINCT ( 'B'[ID] ) ) ),
            "@COUNTRY",
                MINX (
                    FILTER ( ADDRESS, ADRESS[USERID] = FORMAT ( [ID], "0" ) ),
                    RELATED ( 'Flags'[Country] )
                )
        )

EVALUATE
GROUPBY ( C, [@Country], "Count", SUMX ( CURRENTGROUP (), 1 ) )
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
1 year ago

Hi stribor45 

please try

DEFINE
    VAR C =
        ADDCOLUMNS (
            DISTINCT ( UNION ( DISTINCT ( 'A'[ID] ), DISTINCT ( 'B'[ID] ) ) ),
            "@COUNTRY",
                MINX (
                    FILTER ( ADDRESS, ADRESS[USERID] = FORMAT ( [ID], "0" ) ),
                    RELATED ( 'Flags'[Country] )
                )
        )

EVALUATE
GROUPBY ( C, [Country], "Count", SUMX ( CURRENTGROUP (), 1 ) )
stribor45's avatar
stribor45
Icon for Post Prodigy rankPost Prodigy
1 year ago

I tried it and error received was COUNTRY specified in the GROUPBY function was not found in the table