Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Table with filtered rows

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

 

tabela.png

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

 

I tried with
Filter Column =
       UpperLimit VAR = [Upper Limit Express Conv]
RETURN IF ([Conversion Time]> UpperLimit, 1.0)
but I can't call [Conversion Time] in the function

1 REPLY 1
Anonymous
Not applicable

I am not to understand column names...i am guessing last two columns in visual are measure...n if you want to check then simplt use
If( measure1< measure2,1,0)
Add this to visual level filter and set it to 1

If last two columns are not measure then try this measure
If(max(table[col1]<max(table[col2]),1,0)

Thanks,
Pravin

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.