Connecting formulas

[netanel]

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 =

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

Thanks for the helpers!

[Pragati11 · Accepted solution]

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

[Pragati11]

Hi @netanel ,

Can you please accept the right solution to the thread?

I guess the solution was provided by me, just that it had a typo because you didn't share much info at your end.

I understand that @DimaMD, suggested the typo correction, which I would have never done because the person who provides the solution on the thread first should take care of any such issues. Ideally I should have responded with the correction here but saw that it was always answered (which didn't seem to be right :))

As a best practice on the forum, I always avoid jumping in a thread where someone on the forum is always engaged and trying to answer. If the thread is non-responsive for more than a day, then I try to jump in and help with the query. 🙂

But please do accept the right solution to the thread, so atleast who has spent time in creating solution for your query gets the credit. 🙂

Thanks,

Pragati

[mh2587]

Daily AVG  =

CALCULATE([Net USD average per Day], 'Revenues DB'[GL] IN { "InApp", "RV" })
Try this hope it works

[DimaMD]

Hi @netanel 
Try it
Create a tablet:
Table

InApp

RV

Creates a measure

1:
Values = SELECTEDVALUE('Table'[Values])
-------------------------------------- 
2:
Measure =
VAR _fil = [Values]
return
SWITCH(
TRUE(),
_fil = "InApp", [Daily AVG for InApp],
_fil = "RV", [Daily AVG for RV]
)

[netanel]

Hi @DimaMD 

I can not create such a side table

I have  a large database

[Pragati11]

HI @netanel ,

Not sure what do you mean by connecting two formulae?

A little more detail would help here 🙂

Thanks,

Pragati

[netanel]

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]

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]

Hi @Pragati11 

The formula does not work

[Pragati11 · Accepted solution]

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]

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

[DimaMD · Accepted solution]

@netanel 
Remove ")" before the comma 🙂

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