Add And Function to current Formula

[Anonymous]

Hi Experts

having one of those days how would you add an AND function to the following formula...

so that the formula countrows the rows as in the contrainsrow function AND also where the values (rows) in column FTG are null too 

N = 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]))

[v-danhe-msft · Accepted solution]

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

[Anonymous]

Excellent. thanks for the feedback.

Daniel He