Forum Discussion
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]))
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
2 Replies
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