Error when trying to get measures into the report

[Anonymous]

Hi,

I am trying to get the Paginatd report by putting the measure into it.

i.e. I have report working when I am trying to only use columns.

This is the dax I am using 

// DAX Query

Evaluate
SUMMARIZECOLUMNS(
'Sales'[Sales Exec],
'Sales'[Business Manager],
'Sites'[SiteName],
'Sales'[# No Of Sales], -- This is a measure and this is when the error pops in
FILTER(VALUES('Sites'[SiteName]),OR(@Site="All",PATHCONTAINS(@Site,'Sites'[SiteName]))),
FILTER(VALUES('Dates'[Year]),OR(@Year="All",PATHCONTAINS(@Year,'Dates'[Year]))),
FILTER(VALUES('Dates'[MonthNameLong]),OR(@Month="All",PATHCONTAINS(@Month,'Dates'[MonthNameLong]))),
FILTER(VALUES('Sales'[Sales Exec]),OR(@SalesExec="All",PATHCONTAINS(@SalesExec,'Sales'[Sales Exec])))

)

Any help is much appreciated, Thanks in Advance.

[d_gosbell]

This is probably because your syntax is invalid, measures need to be added as expressions after your filters and you need to specify a name for the expression.

eg.

Evaluate
SUMMARIZECOLUMNS(
'Sales'[Sales Exec],
'Sales'[Business Manager],
'Sites'[SiteName],
FILTER(VALUES('Sites'[SiteName]),OR(@Site="All",PATHCONTAINS(@Site,'Sites'[SiteName]))),
FILTER(VALUES('Dates'[Year]),OR(@Year="All",PATHCONTAINS(@Year,'Dates'[Year]))),
FILTER(VALUES('Dates'[MonthNameLong]),OR(@Month="All",PATHCONTAINS(@Month,'Dates'[MonthNameLong]))),
FILTER(VALUES('Sales'[Sales Exec]),OR(@SalesExec="All",PATHCONTAINS(@SalesExec,'Sales'[Sales Exec]))),

"# No Of Sales", 'Sales'[# No Of Sales], -- This is where measure should go

)

[Anonymous]

Hi @d_gosbell ,

I tried to bring the measures at the end, but I am getting the following error.

[d_gosbell]

Yes, that is because your syntax is still invalid. You did not supply a name for the measure column. If you look at the example I provided previously you will see I added a string parameter with the name for the expression column.

,"# Of Sales" , [# Of Sales]

This is because in SUMMARIZECOLUMNS you can put any expression that returns a scalar value, not just a measure reference. 

---