Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

USERELATIONSHIP combined with a Filter

Dear PowerBI Community, I have a problem releted to the combination of a USERELATIONSHIP formule and a Filter.  My initial problem was that I had two differents columns dates (IFD Actual and IFD Pl...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    You need to do the cumulative filtering on the date table, not the model table.

     

    See if this gets you closer:

    IFD_PLANNED =
VAR _MaxDate = MAX ( 'Date 1'[Date] )
RETURN
    CALCULATE (
        COUNT ( 'Model 60'[IFD Planned] ),
        USERELATIONSHIP ( 'Model 60'[IFD Planned], 'Date 1'[Date] ),
        'Date 1'[Date] <= _MaxDate
    )
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

You need to do the cumulative filtering on the date table, not the model table.

 

See if this gets you closer:

IFD_PLANNED =
VAR _MaxDate = MAX ( 'Date 1'[Date] )
RETURN
    CALCULATE (
        COUNT ( 'Model 60'[IFD Planned] ),
        USERELATIONSHIP ( 'Model 60'[IFD Planned], 'Date 1'[Date] ),
        'Date 1'[Date] <= _MaxDate
    )
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks a lot AlexisOlson . This is the correct solution. I have only to do the calculation till today as date but it works perfectly. Thanks again!!!