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!
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?

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

      Anonymous 
      Would you please paste a screenshot of your measure code?

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        tamerj1 

        Changed =
        COUNTROWS (
            FILTER (
                VALUES ( 'Table'[Article] ),
                 CALCULATE ( [Delta], ALL ( Table[Date] ) ) <> 0
            )
        )