Condition is not working

Hi, Anonymous 

Based on the data you provided and the DAX expression, I tested that it works. Here are some of the how-to procedures:

I created three measures using the following DAX expression:

#Gross_FPV = 0
#Gross_FPV_180 = 1
#Gross_otp = -1

I created a condition using the DAX expression you provided:

I created a table visual and tested this condition:

If you see #Gross_FPV_180=1 in measure, you have no problem with your DAX expression. I've uploaded the test file below for you to preview.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.