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

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
    Helper 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
      Community 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.