Report Builder. Help me pls, it should be ready by tomorrow morning.

Anonymous — Mon, 20 Feb 2023 20:10:38 GMT

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

Re: Report Builder. Help me pls, it should be ready by tomorrow morning.

Anonymous — Mon, 20 Feb 2023 20:12:32 GMT

The error message:

topic Report Builder. Help me pls, it should be ready by tomorrow morning. in DAX Commands and Tips

Report Builder. Help me pls, it should be ready by tomorrow morning.

Re: Report Builder. Help me pls, it should be ready by tomorrow morning.