The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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]))
Solved! Go to 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
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
Excellent. thanks for the feedback.
Daniel He
User | Count |
---|---|
65 | |
60 | |
55 | |
54 | |
32 |
User | Count |
---|---|
180 | |
88 | |
70 | |
46 | |
45 |