Forum Discussion

netanel's avatar
netanel
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Gross + if

Hi All!   I have a formula that I can not put together correctly This is the first part of the formula that works great for me: Gross USD average per Day = CALCULATE(     DIVIDE( SUM( 'DB 20...
Need Help
  • netanel's avatar
    netanel
    4 years ago

    Thank you all!
    This is the correct formula:

    Gross USD =
    IF (
    SELECTEDVALUE ( 'db 2021'[Source] ) = "Amazon",
    CALCULATE (
    DIVIDE (
    ( SUM ( 'DB 2021'[Gross USD] ) + SUM ( 'DB 2021'[Fee USD] ) ),
    COUNTROWS ( 'Date' )
    ),
    KEEPFILTERS ( 'Date'[Date] < TODAY () )
    ),
    CALCULATE (
    DIVIDE ( SUM ( 'DB 2021'[Gross USD] ), COUNTROWS ( 'Date' ) ),
    KEEPFILTERS ( 'Date'[Date] < TODAY () )
    )
    )
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

netanel , not sure how that is related to avg gross

You need to have new fee measure

Fee m = calculate(sum('Revenue DB'[Fee]) , filter('Revenue DB', Source <> "Amn" ))

 

This will not show Fee for Source = "Amn"