Forum Discussion

Zemen's avatar
Zemen
New Member
3 years ago

Power BI services report does not match desktop.

I have two columns that count the number of activities completed. There's a 'Prior Work Day' column and a 'Today' column. My dataset is an SQL server. I have refreshes throughout the day to provide up-to-date 'today' count. Typically, our workday is over by 5pm, not considering some users may work overtime.  On the services side, it appears after the last activity was completed, the 'Today' column moved to the 'Prior work Day' column, and there are no results for the 'Today' column. My measures and tables are below comparing desktop vs services. I searched the forum for solutions and have tried adjusting the measures to eliminate any time zone issues, and haven't found a solution. Any suggestions would be helpful. 

TodayCount =

CALCULATE(
    COUNTROWS('Activity'),
    FILTER(
        SUMMARIZE('ABC Time Spent',
        'ABC Time Spent'[Act_Complete_Date]),
        'ABC Time Spent'[Act_Complete_Date] = TODAY()
    )
) + 0
 
PreviousDayCount =
 
VAR CurrentWeekday =
WEEKDAY(TODAY(),2)

VAR PreviousWorkingDay =
SWITCH(
    CurrentWeekday,
    1,TODAY() -3,
    2,TODAY() -1,
    3,TODAY() -1,
    4,TODAY() -1,
    5,TODAY() -1,
    6,TODAY() -1,
    7,TODAY() -2
)

RETURN

CALCULATE(
    COUNT(
        Activity[Act_Name]),
        'Calendar'[Date] = PreviousWorkingDay,
        WEEKDAY('Calendar'[Date], 2) <> 6,
        WEEKDAY('Calendar'[Date], 2) <> 7
) + 0


Desktop Report

Services Report

 

Need Help

3 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Icon for Super User rankSuper User
    3 years ago

    Hello Zemen ,

     

    try refreshing report on service and also try to resert the filters on service incase if there's any filter affecting the result.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

    Follow me on Linkedin

    • Zemen's avatar
      Zemen
      New Member
      3 years ago

      Hey Idrisshatila, 

      I've tried refreshing and republishing my reports but still have the same issue. The service report works as expected throughout the day. The issue seems to arise when the work day is over. Seems to be when the last activity is completed and picked up on the last refresh which I have scheduled for 6pm pacific time.