Selecting filter inside dashboard ruins cummulative measures. RRS feed

  • Question

  • I have dashboard with pie chart and graph and two measures.

    Two measures are:

    Measure1 = CALCULATE(COUNTROWS(Table1),FILTER(ALL(TimeTable),TimeTable[Date]=MAX(TimeTable[Date])&&TimeTable[Time]<=MAX(TimeTable[Time])))

    Measure2 = CALCULATE([Measure1],DATEADD(TimeTable[Date],-1,DAY))

    When I select anything from dashboard this will happen.

    When I use filters (in right side panel) and select same thing it acts normally like this. No idea whats wrong. I think Power BI Designer is wrong.

    Thursday, June 18, 2015 2:23 PM


  • I have changed to basic line chart and it works...
    • Marked as answer by Tomas Ludvik Thursday, June 18, 2015 2:46 PM
    Thursday, June 18, 2015 2:46 PM