Forum Discussion

netanel's avatar
netanel
Post Prodigy
4 years ago
Solved

Connecting formulas

Hi All!   I need help connecting the next two formulas to one formula   Daily AVG for InApp = CALCULATE([Net USD average per Day], 'Revenues DB'[GL] IN { "InApp" })   Daily AVG for RV = ...
Need Help
  • Pragati11's avatar
    Pragati11
    4 years ago

    HI netanel ,

     

    I don't have anything to test the formula, so just wrote it based on my best judgement looking at your description.

    What error the formula is displaying?

    I am assuming you are creating a measure.

    Add more details as I can't help you to troubleshoot this way.

     

    See if this works:

    Net USD average per Day for InApp or RV =
CALCULATE(
         [Net USD average per Day), 
         'Revenues DB'[GL] = "InApp" || 'Revenues DB'[GL] = "RV"
         )

     

    Thanks,

    Pragati

  • DimaMD's avatar
    DimaMD
    4 years ago

    netanel 
    Remove ")" before the comma 🙂

     

     

     

    CALCULATE(
         [Net USD average per Day], 
         'Revenues DB'[GL] = "InApp" || 'Revenues DB'[GL] = "RV"
         )

     

     

     

     

netanel's avatar
netanel
Post Prodigy
4 years ago

Hi Pragati11 

 

I'm trying to get them on the card
But it should contain both RV and InApp
I tried the following formula and it did not work

 

Net USD average per Day for InApp or RV =
CALCULATE(
    [Net USD average per Day],
    'Revenues DB'[GL] IN { "InApp", "RV" }
)

 

Pragati11's avatar
Pragati11
Super User
4 years ago

HI netanel ,

 

You can write a measure as follows:

Net USD average per Day for InApp or RV =
CALCULATE(
         [Net USD average per Day), 
         FILTER(
                'Revenues DB', 'Revenues DB'[GL] = "InApp" || 'Revenues DB'[GL] = "RV"
               )
         )

Thanks,

Pragati

  • netanel's avatar
    netanel
    Post Prodigy
    4 years ago

    Hi Pragati11 

     

    The formula does not work

    • Pragati11's avatar
      Pragati11
      Super User
      4 years ago

      HI netanel ,

       

      I don't have anything to test the formula, so just wrote it based on my best judgement looking at your description.

      What error the formula is displaying?

      I am assuming you are creating a measure.

      Add more details as I can't help you to troubleshoot this way.

       

      See if this works:

      Net USD average per Day for InApp or RV =
CALCULATE(
         [Net USD average per Day), 
         'Revenues DB'[GL] = "InApp" || 'Revenues DB'[GL] = "RV"
         )

       

      Thanks,

      Pragati

      • netanel's avatar
        netanel
        Post Prodigy
        4 years ago

        Hi Pragati11 

         Thanks for your time

        I tried to change the formula based on what you wrote and I do not get the desired result

         

        This is what you wrote