Add And Function to current Formula

Hi Anonymous,

Based on my test, you can refer to below steps:

1.I have entered some sample data.

N = CALCULATE(CALCULATE(COUNTROWS(Data),

                        CONTAINSROW({0,1,11,12,13,14,26,28,34,36,39,43,48,49,50,52,53,54,56,57,58,62,63,69,70,71,72,73,74,75,76,77,78,79,82,84,88,89,94,121,131,132,141,144,146,147,183,186,189},Data[ID])),

                        FILTER('Data','Data'[FTG]=BLANK()))

3.Create a Card visual and add related field, now you can see the correct result.

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/l28pe92d3kcavav/Add%20And%20Function%20to%20current%20Formula.pbix?dl=0

Regards,

Daniel He