Forum Discussion

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

Gross + If

Hi All!   I have this measure: Gross USD=CALCULATE( DIVIDE( SUM( 'DB 2021'[Gross USD] ), COUNTROWS( 'Date' ) ),    keepfilters(  'Date'[Date] < TODAY()))   And I want to put the following condi...
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi netanel ,

     

    You can try below code:-

    Gross USD =
IF (
    SELECTEDVALUE ( 'Table'[Source] ) = "Amn",
    CALCULATE (
        DIVIDE (
            ( SUM ( 'DB 2021'[Gross USD] ) + SUM ( 'DB 2021'[Fee] ) ),
            COUNTROWS ( 'Date' )
        ),
        KEEPFILTERS ( 'Date'[Date] < TODAY () )
    ),
    CALCULATE (
        DIVIDE ( SUM ( 'DB 2021'[Gross USD] ), COUNTROWS ( 'Date' ) ),
        KEEPFILTERS ( 'Date'[Date] < TODAY () )
    )
)

     

    Thanks,

    Samarth

ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
4 years ago

Hi,

You can include IF to your Fee measure. So something like this
Measure = IF(SELECTEDVALUE('Table'[Source])<>"Amn",BLANK(),[FEE])

With this the measure will display blank if the Source is something besides Amn. I hope this helps and if it does consider accepting this as a solution and giving the post a thumbs up!

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

    Hi ValtteriN 

     

    I'm really getting close to the result in the idea you proposed
    Only at the end of the formula:
    Measure = IF (SELECTEDVALUE ('Table' [Source]) <> "Amn", BLANK (), [FEE])

    What is marked in pink is a column in a table and not a formula
    How to bring it?

    • ValtteriN's avatar
      ValtteriN
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Hi,

      Then you can just use the same logic with that column:
      Measure = IF (SELECTEDVALUE ('Table' [Source]) <> "Amn", BLANK (), SELECTEDVALUE('Table'[FEE]))