Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Using unfiltered data in a line chart

Hello guys,   I am struggling to find a solution, the situation is as following   There is a Date slicer where users can select a certain Date range, for example 31-12-2019 to 27-01-2021. Every ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    Please try this measure to get your desired chart.

     

    Test 3 =
    VAR vMinDate =
        MINX (
            ALLSELECTED ( 'Calendar'[Date] ),
            'Calendar'[Date]
        )
    VAR vMinValue =
        CALCULATE (
            SUM ( Facts[Value] ),
            'Calendar'[Date] = vMinDate
        )
    RETURN
        DIVIDE (
            SUM ( Facts[Value] ),
            vMinValue
        )

    Pat

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Please try this measure to get your desired chart.

 

Test 3 =
VAR vMinDate =
    MINX (
        ALLSELECTED ( 'Calendar'[Date] ),
        'Calendar'[Date]
    )
VAR vMinValue =
    CALCULATE (
        SUM ( Facts[Value] ),
        'Calendar'[Date] = vMinDate
    )
RETURN
    DIVIDE (
        SUM ( Facts[Value] ),
        vMinValue
    )

Pat

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Awesome, much appreciated!