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"
         )

     

     

     

     

Pragati11's avatar
Pragati11
Super User
4 years ago

HI netanel ,

 

Not sure what do you mean by connecting two formulae?

A little more detail would help here 🙂

 

Thanks,

Pragati

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