Forum Discussion
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 = ...
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
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]
)
