Forum Discussion
Helper IAlways execute measure on daily resolution
Hi,
Please try something like below if it works.
Loss Limitation = SUMX ( SUMMARIZE ( 'RawData Asset', 'Calendar'[Month] ), CALCULATE ( SUM ( 'RawData Asset'[POA Limitation] ) ) * ( [PR excluding Limitation] - [PR Limitation] ) )Hi,
Thank you for the explanation.
Because I do not fully understand the logic of each measure in the Power BI report, the performance of the newly-written-measure might be slow if the real dataset's size is huge, but for now, please check the attached pbix file.
Super UserHi,
Please try something like below if it works.
Loss Limitation =
SUMX (
SUMMARIZE ( 'RawData Asset', 'Calendar'[Month] ),
CALCULATE ( SUM ( 'RawData Asset'[POA Limitation] ) ) * ( [PR excluding Limitation] - [PR Limitation] )
)
Helper IHello Jihwan_Kim
thanks, it works.
But it's quite sensitive and I don't really know why.
I added a few lines from a adjusted measure. This does not work.
All I did was, changing the substraction within the SUM(x) by doing it befor within a Variable defintion.
How come this does not work anymore?
Loss Limitation =
VAR vDiff = [PR excluding Limitation] - [PR Limitation] RETURN
Sumx(
SUMMARIZE( 'RawData Asset', 'Calendar'[Month]),
CALCULATE(sum('RawData Asset'[POA Limitation])) * vDiff
- Jihwan_Kim
Hi,
Thank you for your message, and please check the link down below.
-> Once resultant values have been calculated for a variable expression, those values do not change, even if the variable is referenced in another expression.