Forum Discussion

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

 

Diff measure : =
VAR _mindate =
CALCULATE ( MIN ( pbitest[rep_date] ), REMOVEFILTERS ( pbitest ) )
VAR _maxdate =
CALCULATE ( MAX ( pbitest[rep_date] ), REMOVEFILTERS ( pbitest ) )
VAR _diff =
CALCULATE ( SUM ( pbitest[atr] ), pbitest[rep_date] = _mindate )
- CALCULATE ( SUM ( pbitest[atr] ), pbitest[rep_date] = _maxdate )
RETURN
IF ( HASONEVALUE ( pbitest[rep_date] ), SUM ( pbitest[atr] ), _diff )

 

 

Link to the sample pbix file 

 

 

  • BItoken's avatar
    BItoken
    Helper III
    5 years ago

    Jihwan_Kim Thanks for the response.

    I tried creating this measure and row level differences are correct but i still see issue at the grand total of the Total (Difference).

    The total difference for the 2 selected dates must be 701 as per the below screenshot

    (250-149+600) but the total shows -329 (Looks like this -329 is consistent no matter what dates we select)