PowerBI Report Builder is not reading PBI Measures causing incorrect calculations

[joshatsps]

Hi all,

I'm having an issue where I cannot get a measure to perform a calculation in Report Builder in the same fashion as it would in PowerBI.

I have simple measure which is meant to calculate some metrics on performance.

Sales Metric = CALCULATE(SUM('fact ReservationsAndCancellations'[ReserveORCancel]), FILTER('dim Calendar','dim Calendar'[HouseSalesWeek] = MAX('dim DevelopmentActiveROS'[FinancialYearWeek])))

In PowerBI, this gives me the performance for the most recent week. I use the same semantic model to run my report builder however this measure gives me some sort of total for all the weeks in the year.

I haven't gotten any closer to figuring this out. ChatGPT and CoPilot aren't helpful and keeps giving me non-existent solutions.

The picture above is correct and suggests that the first Development is the only one to have activity and that too, to have 9 events.

This screenshot is from PBI Report Builder, and for the same selection, it says I have 14 sales for that development but now I have totals for the other developments rather than 0 like previously shown.

I've tried to create a parameter in Report Builder however the calculation I wanted to carry out gave me errors saying that I cannot use aggregates within my expresssion or some sort.

Could someone shed light if this is possible or not?

Many thanks,

Josh

[jennyb11111]

Sorry no answer, but I'm having the same issue, and I think it has something to do with the date filter??

This is an example of my measure that works perfectly in Power BI, but does nothing in Power BI Report Builder:

+ Job Cost =

CALCULATE(

    [+ Estimated Budget],

    FILTER(

        ALLSELECTED('DateActual'[Week End]),

        ISONORAFTER('DateActual'[Week End], MAX('DateActual'[Week End]), DESC)

    )

All other measures in this dataset with no date filters work as expected in Power BI Report builder.  

)

[Elena_Kalina]

Hi @joshatsps 

• Check if you're using the exact same semantic model in both tools

• Verify that both tools are processing the same data (refresh dates)

• Check for any hidden filters in the Power BI visual that might not be present in Report Builder