https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-evaluate-measure-and-several-dimensions/m-p/1310538#M22862 <P>Anonymous</LI-USER> , 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?</P> Thu, 20 Aug 2020 10:32:20 GMT amitchandak 2020-08-20T10:32:20Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-evaluate-measure-and-several-dimensions/m-p/1310489#M22859 <P>I want to check a new measure using DAX query.</P><P>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.<BR />Probably, the query should be looks like this example (it doesn't work):</P><LI-CODE lang="markup">EVALUATE ( FILTER ( ADDCOLUMNS ( VALUES( DimensionTable1[ColumnName1] ), VALUES( DimensionTable2[ColumnName2] ), VALUES( DimensionTable3[ColumnName3] ), "Measure", [Measure] ), DimensionTable1[ColumnName1] IN {( Value1 ), ( Value2 )}, DimensionTable2[ColumnName2] IN {( Value3 ), ( Value4 )} ) )</LI-CODE><P>&nbsp;</P> Thu, 20 Aug 2020 10:13:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-evaluate-measure-and-several-dimensions/m-p/1310489#M22859 Anonymous 2020-08-20T10:13:53Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-evaluate-measure-and-several-dimensions/m-p/1310521#M22861 <LI-CODE lang="csharp">EVALUATE CALCULATETABLE( SUMMARIZECOLUMNS( DimensionTable1[ColumnName1], DimensionTable2[ColumnName2], DimensionTable3[ColumnName3] "Measure", [Measure] ), TREATAS( {Value1, Value2}, DimensionTable1[ColumnName1] ), TREATAS( {Value3, Value4}, DimensionTable2[ColumnName2] ) )</LI-CODE> Thu, 20 Aug 2020 10:27:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-evaluate-measure-and-several-dimensions/m-p/1310521#M22861 Anonymous 2020-08-20T10:27:20Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-evaluate-measure-and-several-dimensions/m-p/1310538#M22862 <P>Anonymous</LI-USER> , 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?</P> Thu, 20 Aug 2020 10:32:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-evaluate-measure-and-several-dimensions/m-p/1310538#M22862 amitchandak 2020-08-20T10:32:20Z