How to evaluate measure and several dimensions?

[Anonymous]

I want to check a new measure using DAX query.

In model I have one fact table and three dimension tables. In excel PIvotTable I can put a measure to the Values section and put 3 separate dimension table attributes to Rows section. I would like to do the same query using DAX.
Probably, the query should be looks like this example (it doesn't work):

EVALUATE (
	FILTER (
		ADDCOLUMNS (
			VALUES( DimensionTable1[ColumnName1] ),
			VALUES( DimensionTable2[ColumnName2] ),
            VALUES( DimensionTable3[ColumnName3] ),
			"Measure", [Measure]
		),
		DimensionTable1[ColumnName1] IN {( Value1 ), ( Value2 )},
		DimensionTable2[ColumnName2] IN {( Value3 ), ( Value4 )}
	)
)

[amitchandak]

@Anonymous , what are trying to achieve here. If you have tables and they are related, filter from dimension slicer will be taken care of by power bi?

[Anonymous · Accepted solution]

EVALUATE
    CALCULATETABLE(
    
        SUMMARIZECOLUMNS(
            DimensionTable1[ColumnName1],
            DimensionTable2[ColumnName2],
            DimensionTable3[ColumnName3]
            "Measure", [Measure]
        ),
        
        TREATAS(
            {Value1, Value2},
            DimensionTable1[ColumnName1]
        ),
        TREATAS(
            {Value3, Value4},
            DimensionTable2[ColumnName2]
        )
    )