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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Delete or hide rows after 0

Hello everyone. Help me with advice on how to do it correctly. There is a value in the F_TEST column(it is circled in red) if its value in F_VAL = 0, then the data that goes to other tests after 0 (Yellow)should not be displayed until the next test (circled in red) is notequal  to 0 

Q DMC.png

1 REPLY 1
BA_Pete
Super User
Super User

Hi @Anonymous ,

 

Not sure I understand your requirements. Why are we not keeping the test results marked below, when the initial test number has F_VAL > 0 ?

BA_Pete_0-1665130883243.png

 

Also, how do we know which test number we are looking for initially? Is it always the one in the first row, or any that have F_VAL = 0, or something else?

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors