Forum Discussion

Jerry1985's avatar
Jerry1985
Frequent Visitor
4 years ago
Solved

Average Ops Days.

I am trying to create a measure for the following:   It takes total Sales / Ops days = Average daily Sales My current measure for Ops days is as follows:   Ops Days = CALCULATE(SUM('PowerBI Dat...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Please try writing a measure like below, and replace the current one with the below.

     

    fixed measure: =
IF (
    HASONEVALUE ( 'Country table'[Country column] ),
    [Your Ops Days measure],
    AVERAGEX ( VALUES ( 'Country table'[Country column] ), [Your Ops Days measure] )
)
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi,

Please try writing a measure like below, and replace the current one with the below.

 

fixed measure: =
IF (
    HASONEVALUE ( 'Country table'[Country column] ),
    [Your Ops Days measure],
    AVERAGEX ( VALUES ( 'Country table'[Country column] ), [Your Ops Days measure] )
)