Forum Discussion

Tob_P's avatar
Tob_P
Icon for Helper V rankHelper V
4 years ago

Filtering on amount >=

I have been working off a piece of DAX that I used previously whereby I only wanted to show sales after a certain date which worked well and wanted to adapt it so that only sales after a certain amou...
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

If [Amount (LCY)] is a measure rather than a column I think you will need to use the FILTER function rather than just passing it as a parameter to CALCULATE. Without the FILTER iterator it has no row context in which to evaluate the measure

Tob_P's avatar
Tob_P
Icon for Helper V rankHelper V
4 years ago

Hi johnt75 - Thanks for coming back to me. It's a column, not a measure.

 

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    4 years ago

    Then the problem would seem to be in other filters which may be being applied. Is there a relationship from the targets table to sales history?

    A good way to see which filters are being applied to a visual is to get the DAX code generated for it from Performance Analyzer and look at that in DAX Studio. Might point you in the right direction