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.  

      • jdbuchanan71's avatar
        jdbuchanan71
        Super User
        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"
)