Forum Discussion

RachelS's avatar
RachelS
Frequent Visitor
5 years ago
Solved

Help on Creating a percentage measure from a current value against a previous value

Hi everyone, I've been trying for a while to create to create a percentage measure to use on a correlated matrix, but the percentage is just coming out wrong. I've trying creating a table storing po...
  • daxer-almighty's avatar
    daxer-almighty
    5 years ago

     

     

    ID Count = DISTINCTCOUNT( Movements[ID] )
    
    % Moved = 
    IF( ISINSCOPE( Movements[CurrentDateText] ),
        var CurrentPeriod = SELECTEDVALUE( Movements[CurrentDateText] )
        var PreviousPeriod =
            TOPN(1,
                FILTER(
                    ALLSELECTED( Movements[CurrentDateText] ),
                    Movements[CurrentDateText] < CurrentPeriod
                ),
                Movements[CurrentDateText],
                DESC
            )
        var CountPreviously =
            CALCULATE(
                [ID Count],
                PreviousPeriod
            )
        var CountNow = [ID Count]
        return
            DIVIDE( CountNow, CountPreviously )
    )

     

    I called the table Movements, obviously...