Forum Discussion

daxreport's avatar
daxreport
Frequent Visitor
3 years ago

Summing a column from a Virtual table

Hello,    In my measure, I have created a Virtual Table using VAR statement. This virtual table uses ALLSELECTED to summarize all the columns available in the current visual along with two measures...
Alf94's avatar
Alf94
Icon for Solution Supplier rankSolution Supplier
3 years ago

Hi daxreport ,

 

Can you please try the following?

 

 

Measure =

SUMX(
    CALCULATETABLE(
        ADDCOLUMNS (
            SUMMARIZE(
                FACTTABLE,
                FACTTABLE[REGION],
                FACTTABLE[CUSTOMER]
            )
            "A", [MEASURE 1]
            "B”, [MEASURE 2]
            ),
        ALLSELECTED()
    ),
    [A]
)

 

 

If I answered your question, please mark my post as a solution.

 

Best,