Forum Discussion
Exclude lines based on multiple criteria
Hi, With below as sample data, my goal is to exlude the first line in sample data shown; whereby the multiple criteria for excluding is: Line Type = Actual Project Type = Funded Exception =...
@gracechong
You can create this measure and assign it to the table visual in the filter pane and set it to 1:New Measure = IF( MAX(data[Line Type]) = "Actual" && MAX(data[Project Type]) = "Funded" && MAX(data[Exception]) = "Yes" && ( MAX(data[Cost A]) <> 0, MAX(data[Cost B] <> 0 )), 1, 0 )________________________
If my answer was helpful, consider Accepting it as the solution to help other members find it
Click the Thumbs-Up icon if you like this answer 🙂
@gracechong
You can create this measure and assign it to the table visual in the filter pane and set it to 1:
New Measure =
IF(
MAX(data[Line Type]) = "Actual" &&
MAX(data[Project Type]) = "Funded" &&
MAX(data[Exception]) = "Yes" &&
( MAX(data[Cost A]) <> 0, MAX(data[Cost B] <> 0 )),
1,
0
)________________________
If my answer was helpful, consider Accepting it as the solution to help other members find it
Click the Thumbs-Up icon if you like this answer 🙂