Forum Discussion

andybamber's avatar
andybamber
Helper III
5 years ago
Solved

Row Context Issues

Hello Everyone!   Hoping someone can help... its a context thing, but i just cant work it out! Attached is a data set which shows the issue...   Essentially i am calculating the difference in Res...
Help with DAX Measure
Measures
  • AntrikshSharma's avatar
    AntrikshSharma
    5 years ago

    andybamber See if this is the desired result:

     

    The file is attached below my signature.

     

    Measure = 
VAR MaxDate = CALCULATE ( MAX ( Resource[snaphot_stamp] ), ALL ( Resource ) )
VAR CurrentWeekAmount = 
    CALCULATE (  
        DISTINCTCOUNT ( Resource[resource_key] ),
        Resource[snaphot_stamp] = MaxDate
    )
VAR LastWeekAmount = 
    CALCULATE (  
        DISTINCTCOUNT ( Resource[resource_key] ),
        Resource[snaphot_stamp] = MaxDate - 28
    )
VAR Result = 
    CurrentWeekAmount - LastWeekAmount
RETURN
    Result
AntrikshSharma's avatar
AntrikshSharma
Community Champion
5 years ago

andybamber See if this is the desired result:

 

The file is attached below my signature.

 

Measure = 
VAR MaxDate = CALCULATE ( MAX ( Resource[snaphot_stamp] ), ALL ( Resource ) )
VAR CurrentWeekAmount = 
    CALCULATE (  
        DISTINCTCOUNT ( Resource[resource_key] ),
        Resource[snaphot_stamp] = MaxDate
    )
VAR LastWeekAmount = 
    CALCULATE (  
        DISTINCTCOUNT ( Resource[resource_key] ),
        Resource[snaphot_stamp] = MaxDate - 28
    )
VAR Result = 
    CurrentWeekAmount - LastWeekAmount
RETURN
    Result