Forum Discussion

atavo's avatar
atavo
Icon for Helper I rankHelper 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

Cmcmahan's avatar
Cmcmahan
Icon for Resident Rockstar rankResident 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
    Icon for Super User rankSuper 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"
)
    • atavo's avatar
      atavo
      Icon for Helper I rankHelper I
      7 years ago

      Thanks jdbuchanan

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

       

      Alfred

      • v-diye-msft's avatar
        v-diye-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        Hi atavo 

         

        Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. others will benefit from here.