Forum Discussion

atavo's avatar
atavo
Helper I
7 years ago
Solved

Please Need DAX Help

  Hi trying to understand why my measure is not working the way it should. I have the following measures: 1. Amount: = SUM(Data[New Funds]) 2. DecisionAmt: = CALCULATE([Amount],            ...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    7 years ago

    Very odd, somehow the FILTER in your measure was interacting with the context to exclude a row although I am not sure why.

    This will return the correct amount for you:

    DecisionAmt Declined = 
CALCULATE(
    [DecisionAmt],
    Data[Report Type]="declined"
)
  • atavo's avatar
    atavo
    7 years ago

    Thanks jdbuchanan

    Would be interesting to know why DAX is behaving this way.

     

    Alfred

jdbuchanan71's avatar
jdbuchanan71
Super User
7 years ago

Hello atavo 

That is odd, any chance you can share your .pbix file?

  • atavo's avatar
    atavo
    Helper I
    7 years ago

    Hi jdbuchanan

    Can do. Any chance I can get your email contact?

     

    Not sure how to upload file on this site.

     

    Alfred

    • Cmcmahan's avatar
      Cmcmahan
      Resident Rockstar
      7 years ago

      I would be interested in seeing your .pbix too.  This is a super weird issue.  I'm curious what happens if you change the third measure to this: 

      DecisionAmt Declined: = CALCULATE([DecisionAmt],
    FILTER(
        Data,
        Data[Report Type]="declined"
))

      The best way to share .pbix files on this forum is to upload it to Google Drive, Dropbox, OneDrive, etc. and post the shareable link.