Forum Discussion

Jacqee's avatar
Jacqee
Icon for Helper I rankHelper I
1 year ago

Weekly total from Calculations by Day

I need to get to a Weekly total from Day Averages.  Totals should be 105.10 for Received and 89.88 for Passed   Here is my current data/visual.  I need to sum the numbers in blue for a Received tot...
Need Help
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
1 year ago

Hi,

I am not sure if I understood your question correctly, but please try something like below whether it suits your requirement.

 

expected result measure: =
SUMX ( VALUES ( 'Custom Calendar'[Day] ), [Daily Avg Overall Recvd] )
Jacqee's avatar
Jacqee
Icon for Helper I rankHelper I
1 year ago

That is super close but I get 112.81 for Received and 97.79 for Passed instead of 105.10 and 89.88.  Any idea why the variance?

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    1 year ago

    Hi,

    if it is OK with you, please share the link of your sample pbix file, and then I can try to look into it.

    Thank you.

    • Jacqee's avatar
      Jacqee
      Icon for Helper I rankHelper I
      1 year ago

      Due to the nature of the data, I'm unable to deitendify it enough to share.