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

v-diye-msft's avatar
v-diye-msft
Community Support
7 years ago

Hi ,

 

Actually I don't think it's needed to add the third measure if you just wanna the [DecisionAmt] changing by slicer, every time you click the slicer, the data will be filtered by specific type. 

But I believe the suggestion provided by jdbuchanan71   does work.