Hi,
My name is Filip, new Report Builder user, Poland.
I wrote a code in DAX Studio:
DEFINE
VAR v_PriceDate =today()-1000
MEASURE 'Price Measures'[Sale price without logistic cost] =
CALCULATE('Price Measures'[Condition Price VF],'Condition'[CON Condition International Type]="ZP01")
MEASURE 'Price Measures'[Sales price with logistic cost] =
CALCULATE('Price Measures'[Condition Price VF],'Condition'[CON Condition International Type]="ZUPR")
MEASURE 'Price Measures'[Margin] =
CALCULATE('Price Measures'[Condition Price VF],'Condition'[CON Condition International Type]="YB07")+
CALCULATE('Price Measures'[Condition Price VF],'Condition'[CON Condition International Type]="YB20")
EVALUATE
SUMMARIZECOLUMNS(
'Material'[MAT WRIN0],
FILTER(VALUES('Distributor'[DIST Country]),OR(('Distributor'[DIST Country] = @DistributorDISTCountry), ISBLANK(@DistributorDISTCountry))),
FILTER(VALUES('Material'[MAT Business ID]),OR(('Material'[MAT Business ID] = @MaterialMATBusinessID), ISBLANK(@MaterialMATBusinessID))),
FILTER ('Price Date', 'Price Date'[PRCD Date] = v_PriceDate),
"Sale price without logistic cost", 'Price Measures'[Sale price without logistic cost],
"Sales price with logistic cost", 'Price Measures'[Sales price with logistic cost],
"Reception Calculated Amount (local curr.)", 'Reception Measures'[Reception Calculated Amount (local curr.)],
"Margin", 'Price Measures'[Margin]
)
And it works there, but Report Builder shows an error when I try to implement it as new dataset.
Can you help me? Thank you
