CODEWITHSUNDEEP
powerbidax
victor amichi
victor amichi

Reputation: 25

Table with filtered rows

How can I filter in the table only the lines where the values of "Conversion Time"> "Upper Limit Express Conv" enter image description here

Since "Upper Limit Express Express" is a variable that is adjusted with Date slicer

Upvotes: 0

Views: 50

Answers (2)

victor amichi
victor amichi

Reputation: 25

This way it worked

Filter Column =
      VAR Conversion Time = SELECTEDVALUE(Autentique[Conversion Time])
Return
      IF(SELECTEDVALUE(Conversion Time)>[Limite Superior Conversão];"A";"B")

Upvotes: 1

CR7SMS
CR7SMS

Reputation: 2584

You could use a filter column to do this:

Filter Column =
      VAR UpperLimit = [Upper Limit Express Conv]
RETURN IF([Conversion Time]>UpperLimit,1,0)

Once the column is created you can simply use it in the filter pane and filter for either 1 or 0 depending on your needs. Hope this helps.

Edit:

Since the column [Conversion Time] is also not readily available, you can try passing that into a variable:

Filter Column =
      VAR UpperLimit = [Upper Limit Express Conv]
      VAR ConvTime = DATEDIFF([Activities.Novo],[Signed_At],DAY)
RETURN IF(ConvTime>UpperLimit,1,0)

Upvotes: 0

Related Questions