Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

FILTER on Measure column

Hello everyone,   I am trying to find a solution for following use case: I have a table where the difference between two values with time-intelligence is calculated by a measure: First measure  ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    tamerj1 

    Found a possible solution by changing your measure into this:

     

    Changed =
    COUNTROWS (
        FILTER (
            ALL ( 'Table'[Price] ), [DeltaPrice] <> 0
        )
    )
     
    It works by returning 1 and afterwards when set in the visual as a filter. 
    Thanks for your support!
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous 
What do you have in the table visual? Can place a screenshot?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi tamerj1 

    this is the visual:

     

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      3 years ago

      Anonymous 
      Place the following measure in the filter pane of the matrix, select is not balnk and apply the filter.

      Changed =
COUNTROWS (
    FILTER (
        VALUES ( 'Table'[Article] ),
        CALCULATE ( [DeltaPrice], ALL ( [Date] ) ) <> 0
    )
)
      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi tamerj1 

         

        thanks, but does not work, because the value of "Changed" is always 1. 

         

        I have also tried this with an if statement by checking the difference between the two values, but the filter did not work. Any other idea?