Forum Discussion

Mangnuel's avatar
Mangnuel
Icon for Helper I rankHelper I
1 year ago
Solved

Always execute measure on daily resolution

Hello, PowerBi World, i need your help. Struggling with the correct calculations while switching between daily and monthly resolution or including more then one month into the report. Attached i...
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
1 year ago

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] )
)
Mangnuel's avatar
Mangnuel
Icon for Helper I rankHelper I
1 year ago

Hello 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's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    1 year ago

    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.

     

    VAR keyword (DAX) - DAX | Microsoft Learn