Forum Discussion

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

filter in measure

HI All

 

I have the following formula:

 

Diff$ Budget = Var _MTDA = CALCULATE([Net USD average per Day]) return _MTDA-[Net USD average per Day for Budget 2021]
 
but I want that "Net USD average per Day" Will arrive only after filtering 
the filter is column Source filter "IN"
 
 
Anyone know how to do this?
 
Thanks!
 
Attach a picture of my filter column
 
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    netanel , try like,  based on what I got

     


    Diff$ Budget = Var _MTDA = CALCULATE([Net USD average per Day])
    return calculate(_MTDA-[Net USD average per Day for Budget 2021], [Source] = "IN")

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    netanel , try like,  based on what I got

     


    Diff$ Budget = Var _MTDA = CALCULATE([Net USD average per Day])
    return calculate(_MTDA-[Net USD average per Day for Budget 2021], [Source] = "IN")