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!