cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Add And Function to current Formula

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

1 ACCEPTED SOLUTION
Microsoft Employee

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.

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Microsoft Employee

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.

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Excellent. thanks for the feedback.

Daniel He

Announcements