Hi,
I have a dataset Query as below.
EVALUATE (
TOPN(20 ,
CALCULATETABLE(
SUMMARIZE(
'OppItem'
,'Account'[Account]
,'Account'[CountryCode]
,'External'[EXTDesc]
,'Opportunity'[Deal]
,'Opp Owner'[Opp Owner]
,'Account'[Account Owner Resource]
,'Opportunity'[Prob]
,'Opportunity'[Fiscal Book Date]
,"XYZ"
,[Sum of Sales]
,"ABC"
,[Sum of Marketing]
,"Margin"
,[Sum of Margin]
)
)
,@Sort,0))
ORDER BY
@sort DESC
When i hard code the value of "Sort" parameter , data is populating correctly.
But when "@Sort" is put , data is in correct and more no.of records are being populated.
Kindly, suggest...