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
    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] )
)
  • Jihwan_Kim's avatar
    Jihwan_Kim
    1 year ago

    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.

     

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

If you want this on daily level you need to calculate the formula separately for each day.

 

PR Limitation = 
SUMX(VALUES('Calendar'[Date]),CALCULATE(divide(sum('RawData Asset'[Yield Limitation]),sum('RawData Asset'[POA Limitation]))))

 

Note:  No need for multiple RETURN statements in your scenario.

Note:  The data model relationship should not be bidirectional.

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

Hi lbendlin 

I adjusted my measures, now I have different Measure for the PR Limitation and included it into the loss Calculation.
But I doesn't work,...

PR Limitation 2 = 

sumx(
    Values('Calendar'[Date]),
    CALCULATE(DIVIDE(sum('RawData Asset'[Yield Limitation]), sum('RawData Asset'[POA Limitation]))
    )
)

 

Loss Limitation classic = 

VAR         vDiff           = [PR excluding Limitation] - [PR Limitation 2]           RETURN
vDiff * sum('RawData Asset'[POA Limitation])